Link should help

http://www.xldynamic.com/source/xld.LastValue.html

VBA Noob