Re: Selecting Multiple Sheets in VBA
- From: "Pete_UK" <pashurst@xxxxxxxxxxx>
- Date: 8 May 2006 05:03:07 -0700
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
.
- Prev by Date: Re: Displaying formulae changes formatting
- Next by Date: Re: How do I copy the value from a cell without copying the formula?
- Previous by thread: Re: How do I copy the value from a cell without copying the formula?
- Next by thread: Re: Selecting Multiple Sheets in VBA
- Index(es):