Error while selecting a range
I am using the following statement to return to first sheet after completing a 'For Next' loop. This throws an error.
This works when I modify this to -Code:Sheets("Cover_Sheet").Range("A1").Select
I have reinstalled Excel and rebooted several times but still this happens. What's wrong and what should I do? Thanks!Code:Sheets("Cover_Sheet").Select Range("A1").Select
Nothing is wrong. You cannot select a range on a sheet that is not active, so you have to activate that sheet first.
You could almost certainly rewrite your For...Next loop so that it doesn't change the active sheet when it runs though.
So long, and thanks for all the fish.
Thanks romperstomper.
This looks bit strange not to be able to directly select a range. This may be Excel's fault. Many thanks to you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks