Select worksheet using a variable

[Neal Ostrander]

I am trying to copy data from one worksheet into another based on the value
in one of the cells in the original worksheet.
I have declared the variable and set the Sheets.select as follows

Dim sheetName
Sheets(sheetName).Select

when the code gets to the Sheets(sheetName).Select line it gives a Runtime
error and says Subscript out of range. Any ideas why this is happenig and how
to correct it.
Thanks
Neal

 

[Bob Phillips]

It means that there is not a worksheet with the name that is contained
within the variable SheetName. You have either mis-spelt, or not loaded it
into that variable.

 

[Sheeloo]

You have not assigned any value to the variable sheetName before using it...
Try

Dim sheetName

sheetName = "Name of your sheet here"