View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Holmes Fred Holmes is offline
external usenet poster
 
Posts: 112
Default 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