Jeff,

It may be that sheet "linforce" isn't the active sheet at the time. Every sheet has
selected cells, and an active (the white) cell, but you have to explicitly activate the
sheet containing the cell you wish to select. I think the Range("A1") doesn't fail because
it selects A1 of the active sheet, whatever it happens to be.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeyl.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
Hi,

I was trying to copy stuff but I am getting an error.

Set tRange = Sheets("Iinforce").Range("A1")
tRange.Select

Error = "Selection method of range class failed"

Why is this an error when you can legally tye Range("A1").select?
Isn't my code the same thing?

Thanks for your help