Thanks much Gord and Biff. I have been programming for some time, but have
never done much in Excel before. I was not aware that it would return the
last "less than" match if it didn't find an exact match. Also, I would have
thought all the #DIV/0!'s would have produced an error.
Thanks!
Cat
"Biff" wrote in message
...
Depending on what type of data is involved, some methods are better than
others.
See this for a definitive guide:
http://xldynamic.com/source/xld.LastValue.html
Biff
"Cat Chowdy" <catchowdyathotmaildotcom wrote in message
...
I am trying to get the last value in a column. I don't know what row that
will be in - as that can vary. How can I address the last filled in cell
in a specific column?
Thanks,
Cat