A few questions. How do I get to the next worksheet in a VBA macro?
I.e. I have created a "next" macro to perform the same functions on the ActiveSheet but I can't get the macro make the next worksheet active
Is there a Next.Sheet command or I have tried this
Workbooks(ActiveSheet +1).Select but it is not working. Any ideas?
I.e. I have created a "next" macro to perform the same functions on the ActiveSheet but I can't get the macro make the next worksheet active
Is there a Next.Sheet command or I have tried this
Workbooks(ActiveSheet +1).Select but it is not working. Any ideas?