selecting multiple worksheets

  • Thread starter Thread starter dolphinv4
  • Start date Start date
D

dolphinv4

Hi,

I need to have a macro such that it'll select all sheets
from the first to the sheet before a sheet called "test".
After selecting these sheets, i want to make simultaneous
changes to them. So how do I add the code in the macro to
choose all these sheets?

I can't put the names of the sheets coz the names changes
often.

THanks!
noel
 
Back
Top