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 -