Using variable names to select sheet names

Im trying to select a sheet by using it's sheet index.

i.e. selecting using Sheet1.select NOT by using sheets("Title").select

I'm going to illustrate my problem by showing you my coding so far:

Please Login or Register  to view this content.

Underlined is where the program crashes. Is there a way I can use the variable name to select the sheet via its index??

Originally Posted by davesexcel

Maybe this....

Sheets(i).Select

Thanks you. That worked a treat