Parsing a column range

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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
 
Hi
if you have no blanks cells in between you may use
=OFFSET($A$1,COUNTA(A:A)-1,0)
 
Charlie

one way:

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

Regards

Trevor
 
Back
Top