ActiveCell.EntireRow.copy
--
Regards,
Tom Ogilvy
"scottnshelly" wrote:
I need a line of code to copy an entire active row. I have a loop to
find cells in A:A that meet a certain criteria. If that is met, I want
to copy the entire active row to paste onto a different sheet.
Thanks.
--
scottnshelly
------------------------------------------------------------------------
scottnshelly's Profile: http://www.excelforum.com/member.php...fo&userid=7301
View this thread: http://www.excelforum.com/showthread...hreadid=551988