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 Misc
Help with a macro
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Roger Govier, post: 3279666"] Hi It is failing because to need to either Activate a Sheet, before you can select or activate a cell. There is no need to be selecting sheets however, you can just do a straight copy from Sheet 1 to Sheet 2 as in the code below Sub Wombat() Sheets("1").Cells(3, 12).Select x = 3 y = 24 Do Until Cells(x, 12).Value = "END" If Cells(x, 12).Value <> "" Then Cells(x, 12).Copy Sheets("2").Cells(y, 1) x = x + 1 y = y + 1 Else x = x + 1 End If Loop End Sub [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Help with a macro
Top
