[RESOLVED] what is the vb code to copy rows from one sheet to another?

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?

Is it something like this WORKsht.Cells(wRow) = DATAsht.Cells(wRow)?
I really have no idea, if anyone knows ?

Thanks

Macros are your friend.. record a macro of what u need to do then check the code :)

Quote:

---

Originally Posted by Static

Macros are your friend.. record a macro of what u need to do then check the code :)

---

thanks it worked! much simpler to record a macro and then copy/edit the code to suit my needs than to figure out how to write the code from scratch!!!

why did i think of this earlier??

thanks!