Jeff,

The issue is which sheet is active at the time you try to activate or select tRange.. It
must be linforce" for it to work.

Dim tRange As Range

Set tRange = Sheets("linforce").Range("A1")
Sheets("linforce").Activate
tRange.Activate

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeyl.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
I tried

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

also but that didnt work.


"Earl Kiosterud" wrote:

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