Problem with Excel select command

[eAlchemist]

Can someone tell me why this line of code comes back with a Run-time error 1004 when I run it? It doesn't error out when I run it in the immediate window

Sheets("Sales Index").Range(Cells(3, 56), Cells(Sheets("SalesIndex").Range("A2").SpecialCells(xlLastCell).Row, 107)).Select

 

[PHV]

Your sheet is named "Sales Index" or "SalesIndex" ?
Try to always qualify the Cells property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[eAlchemist]

That was a mistake in my copying it. It's correct as "Sales Index" in both places.

Thanks,
Chris