If you cant to copy everything (including formats):

Worksheets("Sheet2").Rows(10).Copy _
dest:=Worksheets("Sheet1").rows(10)

To copy values only:
Worksheets("Sheet1").rows(10).value = _
Worksheets("Sheet2").Rows(10).Value

HTH
--
AP

"bxc2739" a écrit
dans le message de news:
...

Can someone please help tell me what is the correct syntax/ie vb code
to copy a entire row from one sheet to another?

Pretend I have two sheets and want to copy an entire row from sheet2
to sheet one , what is the code to do something like this?

I know I can do it manually, but for what I am doing I need
the macro code to do it automatically.

Thanks


--
bxc2739
------------------------------------------------------------------------
bxc2739's Profile:
http://www.excelforum.com/member.php...o&userid=32538
View this thread: http://www.excelforum.com/showthread...hreadid=545604