selecting multiple worksheets

[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

 

[Ron de Bruin]

Look in your other thread for a possible answer
Please post in one group