Hi Excel Monkey,

Try:

VbImportSheet.Select

---
Regards,
Norman



"ExcelMonkey" wrote in message
...
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