View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Name sheets in VB and Selecting them.



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