2010 - Reference last value in column with variable rows

[jdunlap]

I have a list of data that is constantly being appended so my last row constantly moves down, but not always the same number of rows each time. I want another cell to reference the value in the last cell of the column. How can I ensure it will always find the last cell in the column?

 

[Marcelo Branco]

Hi,

Take a look at

http://www.mrexcel.com/forum/showthread.php?t=18954

HTH

M.

 

[jdunlap]

Thanks much!

 

[Marcelo Branco]

Thanks much!

You are welcome and tks for the feedback

M.