Re: Selecting Multiple Sheets in VBA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



If you can do it manually, why can't you record a macro while you do
it? Then you will be able to see the syntax and should be able to merge
the recorded macro (or parts of it) into your other macro. You could
insert two sheets "first_temp" and "last_temp", position them at the
appropriate places, then make use of these. Once you have finished,
"first_temp" and "last_temp" could be deleted.

Hope this helps.

Pete

.


Quantcast