Copy Range object
Hi Jan,
yesterday i wrote this sentence:
Worksheets("Sheet1").Range("9:9")=Worksheets("Shee t2").Range("15:15")
but on worksheet 1 was nothing hapened!
Regards,
Milos
"Jan Karel Pieterse" wrote in message
...
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
.
|