| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
GoTo Reference
Thank You Very Much For Your Help!!!!
"Jim Thomlinson" wrote: Every sheet has a tab name and a code name. By refering to the code name you eliminate the problem of changes made to the tab name. Try this... Sheet1.Select Sheet1.Range("A154").Select You can change the Code name of the Sheet in the properties window of the VB editor. The code name is the top item in the properties list. You can change Sheet1 to something a little more descriptive like shtIncomeStatement ... -- HTH... Jim Thomlinson "MWS" wrote: Hello, Can someone tell me if it's possible to refer to a worksheet generically, when using the GoTo function, so if the worksheet name changes, the code will still execute? For instance, I have the following: Application.Goto Application.Worksheets("Sheet1").Range("A154") If the the Sheet1 name changes, the process halts. Can Sheet1 be reference in a manner that regardless of the text within the worksheet label, the code will still take the user to range("A154")? Any and All Help is Appreciated - Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application.Goto Reference gets error 1004 | Excel Discussion (Misc queries) | |||
| Application.Goto reference:="MyCell" | Excel Programming | |||
| On Error Goto doesn't goto | Excel Programming | |||
| On Error Goto doesn't goto | Excel Programming | |||
| 'Application.Goto Reference | Excel Programming | |||
Threaded Mode
