Automatically selecting the next empty row

[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.

[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



Alec H wrote:
>
> 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.
>
> --
> Alec H
> ------------------------------------------------------------------------
> Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
> View this thread: http://www.excelforum.com/showthread...hreadid=515357

--

Dave Peterson

[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