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