This line only works when the 1st sheet is the active sheet. It doesn't work when the others are active.
Cells.Select
When the 3rd worksheet is selected, this isn't working on the 1st sheet:
Worksheets(1).Cells.Select
And to further complicate matters, these things do not ALWAYS work or fail. I'm not sure how to explain this. Any ideas?
cells.select will only work if the code is the sheet module of the active worksheet. If its in the workbook module you'll need activesheet.cells.select. To complicate further you can't select cells on a sheet that is not the active sheet.
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."
One can Select Cells ONLY on the Active Sheet. However, one rarely needs to Select...what is it you're trying to do?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Yep,
It looks like you'll need to do a 2 statement code of:
to get what I think you want.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks