I put quotes in: Sheets("VbImportSheet").Select
and this did not work either.

Why?

"ExcelMonkey" wrote:



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