Jim Jackson
12/11/2006 4:36:00 PM
If the variable range always has a blank row beneath it, or the cell below in
Column A is empty:
Dim rng
With Cells
Set rng = .Range(.Cells(1,1),.Cells(1,1)).End (xldown)
rng.Select
This will select the last cell in Column A that has data.
*(1,1) refers to Row 1 and column 1
If column 20 will have data in the last row you can use (1,20),.(1,20)
instead of the above.
Of course, setting (rnumber,colnumber) according to your data's position.
--
Best wishes,
Jim
"Gert" wrote:
> Hi all,
>
> Is there a formula to pick the last item out of a (variable) range
>
> thanks in advance
> Gert
>
>