Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding worksheets by using variable names
Hi,
Sheets are named "Jim" "Tom" "Judy" etc. The MASTER sheet also has these names in a table. I want to click on a cell containing "Tom" and have the code jump to the Tom sheet. I tried this: AAA=Activecell.value ' the cell contains word "Tom" Sheets(AAA).select 'should find Tom sheet But I get an error message, probably because VB is expecting the AAA to be in quotes, and it's no recognizig that AAA is a variable value. Help appreciated Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding worksheets by using variable names
Hi Paul
With a sheet named Tom this worked fine he Sub test() Dim AAA As String AAA = "Tom" Sheets(AAA).Select End Sub But I get an error message, probably because VB is expecting the AAA to be in quotes No. What did the message actually say ? Best wishes Harald "Paul" skrev i melding ... Hi, Sheets are named "Jim" "Tom" "Judy" etc. The MASTER sheet also has these names in a table. I want to click on a cell containing "Tom" and have the code jump to the Tom sheet. I tried this: AAA=Activecell.value ' the cell contains word "Tom" Sheets(AAA).select 'should find Tom sheet But I get an error message, probably because VB is expecting the AAA to be in quotes, and it's no recognizig that AAA is a variable value. Help appreciated Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference other worksheets via variable names | Excel Worksheet Functions | |||
Finding the names that are not there | Excel Discussion (Misc queries) | |||
Finding Latest Variable | Excel Discussion (Misc queries) | |||
Finding unique names--then converting those names to unique number | Excel Discussion (Misc queries) | |||
Finding Names | Excel Worksheet Functions |