Move to next worksheet

[techu4]

Hi All,

I have been seatching for ages and cannot seem to find a way of moving to the next worksheet in excel without knowing it's name.

Does anyone know who i can do this. I can open the workbook and count the number of sheets but can't seem to be able to move to the next sheet without it's name.

Please help as I am pulling my hair out.

Regards

techu4

 

[HarleyQuinn]

As far as I can remember you (depending how you are using Excel) can use the index of the sheet instead of the name.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[techu4]

Hi HarleyQuinn,

thanks for that I will give it a try.

Regards

 

[combo]

You can also use worksheet's Next property, returns the next available worksheet or nothing.

combo