Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am tyring to select a sheet in VB. I want to avoide using the sheet name as the user may change this over time. I clicked onto the sheet in the VBA Project Window and then went into the Name proptery in the Proptery window and named it "VbImportSheet". When I use the followig line of code I get an error: Worksheets(VbImportSheet).Select The error is a Run Time Error 9 Subscript out of range What am I doing wrong? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting all sheets | Excel Programming | |||
Selecting all sheets | Excel Programming | |||
Selecting all sheets | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
selecting sheets | Excel Programming |