Last Value in Column =INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A1000))*(A1:A 1000<"")))) Last Numeric value
=LOOKUP(9.99999999999999E+307,A:A) Last Text value =MATCH(REPT("z",255),A:A)Sub GotoBottomOfCurrentColumn() 'Tom Ogilvy
2000-06-26 Cells(Rows.Count, ActiveCell.Column).End(xlUp).SelectEnd SubMore information
http://www.mvps.org/dmcritchie/excel/toolbars.htm http://www.mvps.org/dmcritchie/excel/lastcell.htm---HTH, David McRitchie,
Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page:
http://www.mvps.org/dmcritchie/excel/search.htm "bcamp1973" wrote
is there a way to capture the value of the last populated cell in a
column?