Select worksheet using a variable
 

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

Select worksheet using a variable
 

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.

--
__________________________________
HTH

Bob

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

Select worksheet using a variable
 

You have not assigned any value to the variable sheetName before using it...
Try
Dim sheetName
sheetName = "Name of your sheet here"
Sheets(sheetName).Select


"Neal Ostrander" wrote:

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