Hi
try
worksheets(your_number).activate

--
Regards
Frank Kabel
Frankfurt, Germany

"Fred Holmes" schrieb im Newsbeitrag
...
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