You can only select a range if its worksheet is active/selected.

so one way...

with worksheets(strWrkSht)
.select
.range(.cells(2,2),.cells(intCopyTo1,intCopyTo)).s elect
end with

But maybe you could just do what ever you had to do to that range without
selecting it:

with worksheets(strWrkSht)
'.select
.range(.cells(2,2),.cells(intCopyTo1,intCopyTo)).c learcontents
end with


Note the additional dots in front of the .cells(). This means that this object
belongs to the object in the previous With statement.


SHIPP wrote:

I am working in Excel 97 and am getting a 1004 error - Application defined or
object defined error. The code is

Worksheets(strWrkSht).Range(Cells(2, 2), Cells(intCopyTo1,
intCopyTo)).Select

I have stepped through the code to determine the value of the variables:

intCopyTo1=211
intCopyTo = 6
strWrkSht=Master

All variables are accurate. Any help would be appreciated.
--
M. Shipp

--

Dave Peterson