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

Giganews Newsgroups
Subject: what is the vb code to copy rows from one sheet to another?
Posted by:  bxc2739 (bxc2739.28dlry_1148581803.8478@excelforum-nospam.com)
Date: Thu, 25 May 2006

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?action=getinfo&userid=32538
View this thread:http://www.excelforum.com/showthread.php?threadid=545604

Replies