I gotcha, i guess i didn't look close enough to see actually selecting the
cells, too long at work i guess!
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jim Thomlinson" wrote:

Yes you can get the value of the cell but you can not select the cell. The
select method of a range fails if the worksheet that the range is on is not
the active sheet. Run this code on a new worksbook

sub test
sheets("Sheet2").select
sheets("Sheet2").range("C3").select
msgbox "OK to here... but get ready to crash"
sheets("Sheet1").range("C3").select
end sub

--
HTH...

Jim Thomlinson


"John Bundy" wrote:

Not sure what you mean by "You can only select a cell on an active worksheet.
If the sheet is not active then the code will crash" Jim. I can get data from
any sheet i want, active or not without a select. As long as you include the
sheet name or index.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jim Thomlinson" wrote:

You can only select a cell on an active worksheet. If the sheet is not active
then the code will crash... unless you use application.goto something like
this...

application.goto Worksheets("working data").Range("A" & rowx & ": K" & rowx)

or

with Worksheets("working data")
.select
.Range("A" & rowx & ": K" & rowx).Select
end with

--
HTH...

Jim Thomlinson


"Eric @ BP-EVV" wrote:

What's wrong with the following statement that would cause the error: Select
method of Range Class failed ??

Worksheets("working data").Range("A" & rowx & ": K" & rowx).Select

Thanks !