Go to Next Empty Field

C

cassy01

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

thanks
ben
 
R

R..VENKATARAMAN

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