Query sheet to activate
 

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

Query sheet to activate
 

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

Query sheet to activate
 

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

--
Don Guillett
SalesAid Software

"Frank Kabel" wrote in message
...
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

Query sheet to activate
 

Works just fine.

Many thanks,

Fred Holmes

On Tue, 6 Apr 2004 01:08:04 +0200, "Frank Kabel"
wrote:

Hi
try
worksheets(your_number).activate