I found the same in xl2000, but this worked

Worksheets("Sheet1").Range("9:9").Value= _
Worksheets("Sheet2").Range("15:15").Value

--
Regards,
Tom Ogilvy

"M." wrote in message
...
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


.