Query sheet to activate

[Fred Holmes]

The statement

sheet1.activate

activates an explicit worksheet.

How can I write the statement for a general sheet number, where the
number, n, is a response to an InputBox?

Integer n
n = InputBox("Which worksheet do you want to jump to?")

The code in a statement isn't something I can concatenate as a string
variable??

Thanks,

Fred Holmes

 

[Frank Kabel]

Hi
try
worksheets(your_number).activate

 

[Don Guillett]

Frank,
OP is trying to use an input box to enter a sheet code number and select
that sheet.

 

[Fred Holmes]

Works just fine.

Many thanks,

Fred Holmes