G
Guest
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
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