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 !

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 !

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 !

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 !

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 !

The obvious:

What is the value of rowx at the time this statement is executed? Also
what is rowx declared as?
Is there a worksheet named "working data"?

--JP

On Aug 13, 4:37*pm, 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 !

Thanks to the three of you for some interesting banter....I got the issue
resolved....perhaps it was that rowx wasn't being properly set as JP implied,
perhaps it was something else....I hate to say I don't recall what I did to
fix it but it works good now. (Too much time at work for me too !)


"JP" wrote:

The obvious:

What is the value of rowx at the time this statement is executed? Also
what is rowx declared as?
Is there a worksheet named "working data"?

--JP

On Aug 13, 4:37 pm, 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 !

If there is a way you can execute your code without doing any
"selecting", it would make the code faster and less error prone.

--JP

On Aug 14, 8:53*am, Eric @ BP-EVV
wrote:
Thanks to the three of you for some interesting banter....I got the issue
resolved....perhaps it was that rowx wasn't being properly set as JP implied,
perhaps it was something else....I hate to say I don't recall what I did to
fix it but it works good now. (Too much time at work for me too !)



"JP" wrote:
The obvious:

What is the value of rowx at the time this statement is executed? Also
what is rowx declared as?
Is there a worksheet named "working data"?

--JP

On Aug 13, 4:37 pm, 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 !- Hide quoted text -

- Show quoted text -

That line works perfectly for me, what value is rowx set to?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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 !