I have the following which works fine when I'm on Sheet 1. When I select any other sheet and run the script, I get an error, though. What did I miss?
Please Login or Register to view this content.
I have the following which works fine when I'm on Sheet 1. When I select any other sheet and run the script, I get an error, though. What did I miss?
Please Login or Register to view this content.
You either quit or become really good at it. There are no other choices.
Qualify Sheets(1) for each Cells reference
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
That works! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks