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 !