software

I am writing a macro that copies cells from one sheet and puts it on
another sheet in the next empty field how do i do this ?

thanks
benn--
cassy01
------------------------------------------------------------------------
cassy01's Profile: www.excelforum.com/member.php...nfoamp;userid=780
View this thread: www.excelforum.com/showthread...hreadid=514335in vba use this type of code
sheet2.range(rows.count,
cells(rows.Count,quot;Equot;).end(xlup).offset(1,0).pastes pecial
it will be pasted next empty cell in column E
gt; wrote in message
...
gt;
gt; I am writing a macro that copies cells from one sheet and puts it on
gt; another sheet in the next empty field how do i do this ?
gt;
gt; thanks
gt; benn
gt;
gt;
gt; --
gt; cassy01
gt; ------------------------------------------------------------------------
gt; cassy01's Profile:
gt; www.excelforum.com/member.php...nfoamp;userid=780
gt; View this thread: www.excelforum.com/showthread...hreadid=514335
gt;