Excel VBA Sheet(variable).range... possible ?
 

Hi Everyone,

is it possible to add a variable to the sheet(var).range("A1").select
expression? I know of the sheets("name") expression, but this is a workbook
that contains multiple sheets, no naming convention, and requires me to go
back, forth and skip some sheets depending on user input.

Example:

Var = 10
sheet(Var).range("A1").select

would give:
sheet10.range("A1").select

Excel VBA Sheet(variable).range... possible ?
 

Sub tst()
Var = 3
Sheets("Sheet" & Var).Activate
Range("A1").Select
End Sub


"Phil" skrev:

Hi Everyone,

is it possible to add a variable to the sheet(var).range("A1").select
expression? I know of the sheets("name") expression, but this is a workbook
that contains multiple sheets, no naming convention, and requires me to go
back, forth and skip some sheets depending on user input.

Example:

Var = 10
sheet(Var).range("A1").select

would give:
sheet10.range("A1").select