Try Bob Phillips' marvellous coverage at his page at:
http://www.xldynamic.com/source/xld.LastValue.html
(Formula and vba solutions provided)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Needles" wrote in message
...
I am trying to create a macro that will copy the last non-blank cell in a
running total column that appears on a number of worksheets to a summary
worksheet in the same workbook. Any suggestions?