Go to Next Empty Field
 

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: http://www.excelforum.com/member.php...nfo&userid=780
View this thread: http://www.excelforum.com/showthread...hreadid=514335

Go to Next Empty Field
 

in vba use this type of code
sheet2.range(rows.count,
cells(rows.Count,"E").end(xlup).offset(1,0).pastes pecial
it will be pasted next empty cell in column E



wrote in message
...

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:
http://www.excelforum.com/member.php...nfo&userid=780
View this thread: http://www.excelforum.com/showthread...hreadid=514335