I want to have my macro select the next sheet in a spreadsheet. I have tried recording the macro with relative references, but it still gives the tab name in the code. (??)
I am doing this within a loop and just want excel do what it needs to on the first sheet, go to the next sheet and start again/loop until finished (about 35 times). How can I get it to go to the next sheet without having to name it??
I apologize if this is a dumb/simple question, but this is Macro stuff is pretty new to me and any advice would be greatly appreciated!! Thanks!
I am doing this within a loop and just want excel do what it needs to on the first sheet, go to the next sheet and start again/loop until finished (about 35 times). How can I get it to go to the next sheet without having to name it??
I apologize if this is a dumb/simple question, but this is Macro stuff is pretty new to me and any advice would be greatly appreciated!! Thanks!