View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wh0079 Wh0079 is offline
external usenet poster
 
Posts: 8
Default Reference the last cell in a column

Hello.
I am looking to reference the last cell that contains data from one sheet
onto another sheet in my workbook. The issue I am having with this is that
this cell will change (however I can limit the reference to a specific
range).
Is there a way to dynamically reference a range of cells without having to
go back and adjust the lookup manually?