Chip - how can I get that value into, say, cell D15? And where do I paste
that programming? Please
excuse my ignorance :-)

Bill

"Chip Pearson" wrote in message
...
Bill,

Try something like

Dim LastRng As Range
Set LastRng = Range("IV15").End(xlToLeft)
MsgBox LastRng.Address


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excelwiz wanabee" wrote in
message .. .
Hi,

I'm wondering if ya'll excel "wizards" can help me out. I want
to be able to
get the "last entered" value for a particular row and subtract
from it a
fixed field (i.e. L15-F15 where L15 is the last entered value
(or G15, H15,
etc.; increments monthly) and F15 is a field that does not
change in the
equation.)

Thanks,

Bill