Error in Range Statement

[Guest]

Does anyone know why this gives an error?

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

 

[Ed]

Works fine for me (XL2k). Would suggest either a Debug.Print or MsgBox
statement for each variable before this line to verify that each variable
does indeed have the expected value.

Ed

 

[Bob Phillips]

What error does it give?

What values are in strWrkSht, intCopyTo, intCopyTo1? Does that worksheet
exist?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

You may have missed one reply at your first post:
http://groups.google.co.uk/[email protected]