Activating a Worksheet with a changing name

  • Thread starter Thread starter Sean Stuber
  • Start date Start date
S

Sean Stuber

I can't figure out why i am getting an error in this code trying to
activate the worksheet refered to by "answer" where answer might be a
string 7898789 which was entered into cells (1,1). I know normally to
refer to a sheet it needs "" ...

answer = Worksheets("NewReport").Range("ShopOrder").Cells(1, 1)
Worksheets(answer).Activate

any ideas?
 
Without testing for existence of that worksheet:

worksheets(cstr(answer)).activate

Worksheets("1")
is different than
worksheets(1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

the default worksheet 3
Combine three InputBoxes into one? 7
InputBox for column letter problem 2
Control a worksheet w/o activating 7
Find value of active cell in other visible worksheets 8
clear all sheets code 4
Macro to combine worksheets 10
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top