Hitting F4 after selecting your cell or range will automatically put $
signs
in front of each reference.
--
mphell0
------------------------------------------------------------------------
mphell0's Profile:
http://www.excelforum.com/member.php...o&userid=30153
View this thread:
http://www.excelforum.com/showthread...hreadid=507720