The 2nd worksheet is currently the active one. Why aren't these working?
Please Login or Register to view this content.Please Login or Register to view this content.
The first line of code should select all cells on the 2nd worksheet. The next line of code should select all cells on the 3rd worksheet.
There are millions of cells on a page. How about usedrange.select
e/ On a side note you can't select if its not the active sheet.
Last edited by Solus Rankin; 08-19-2013 at 04:07 PM.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks