VBA code to select worksheets regardless their name

[Chiroboc]

i need to go from a worksheet to another, regarless their name. I already have a VBA code to split my data into worksheets, but everytime they have a different name since the information from the database is always different. I read somenthing about the "sheet system name" but i don't understand it completetly. :D

please help!

thanks in advance!

[stnkynts]

You have to able to tell the code which sheet you are referring to somehow. One way is by the sheets name, another is by the sheets index number which is the order in which the sheet is tabbed. For example Sheets(1) would be the first sheet or sheet1 by default. Sheets(2) would be the second sheet or sheet2 by default. The last way, which is a little more trickey, would be to run a loop through all sheets and then check for a certain perameter in only the sheets you want. You would do it like this

Please Login or Register  to view this content.