Parsing a column range

[Charlie]

I need a function to parse a column range. When the cell
containing the last number within the range is located,
that number will be used in another funtion in another
cell. The range will remain constant but the cell
containing the last number will be variable. Example the
range A1-A12. In January the last number would occur in
A1, in February it would be A2, etc.

Thanks

 

[Frank Kabel]

Hi
if you have no blanks cells in between you may use
=OFFSET($A$1,COUNTA(A:A)-1,0)

 

[Trevor Shuttleworth]

Charlie

one way:

Function LastRowA()
Application.Volatile
LastRowA = Range("A" & Rows.Count).End(xlUp).Row
End Function

Regards

Trevor