Hi,

Without copying (shape of range needs to be identical):

Worksheets("Sheet1").Range("A1:B2")=Worksheets
("Sheet2").Range("A1:B2")

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Hi,

i'd like to copy one "x" row on worksheet1 to "y" row on
worksheet2 or range
1 on worksheet1 to range 2 on worksheet2. Could i copy
(assign) one range to
another without use copy or copy/pase metod?

Thanks

Milos


.