Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Update this macro to make it generate a counter as text
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Claus Busch, post: 7410077"] Hi Am Wed, 17 Oct 2012 09:14:02 -0700 (PDT) schrieb B Roberson: try: Sub add_page_and_line_new() Dim cRows As Long cRows = Cells(Rows.Count, "A").End(xlUp).Row With Range("D1:D" & cRows) .Formula = "=row()" .Copy .PasteSpecial xlPasteValues .NumberFormat = "000" End With End Sub Regards Claus Busch [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Update this macro to make it generate a counter as text
Top
