Automatically selecting the next empty row

A

Alec H

Hi,

I want to tell my macro to paste data gathered earlier in its process
into the first available empty row on a worksheet.....

Any help appreciated

Alec.
 
D

Dave Peterson

Can you pick out a column that always has data?

I used column A in this example:

dim DestCell as range
with worksheets("sheet99")
set destcell = .cells(.rows.count,"A").end(xlup).offset(1,0)
end with

somerange.copy _
destination:=destcell
 
A

Alec H

Can you pick out a column that always has data?

I used column A in this example:

dim DestCell as range
with worksheets("sheet99")
set destcell = .cells(.rows.count,"A").end(xlup).offset(1,0)
end with

somerange.copy _
destination:=destcell





Dave Peterson




Sorted, Thanks Dave :)
 
Top