Using variable names to select sheet names

**mattsgr1** · 02-13-2007, 06:10 AM

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:

Sub Test()
Dim sheetcount As Integer
Dim i As Integer

sheetcount = ActiveWorkbook.Sheets.Count
Application.ScreenUpdating = False


If sheetcount = 20 Then
    Call Set_Screen_Properties
    For i = 1 To 20
        i = i + 1
        sheeti.Select
        Call Add_Hyperlink
        Selection.Name = ("Txt_1")
    Next
End If

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