In that case

spnCalc.Value = CLng(Range("A1").Value)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"vbawannab" wrote in message
...

Thanks, Bob. The user is entering values directly into cells. Ideally
I'd like to pull the value from the cell.


--
vbawannab
------------------------------------------------------------------------
vbawannab's Profile:
http://www.excelforum.com/member.php...o&userid=16784
View this thread: http://www.excelforum.com/showthread...hreadid=319806