Helen Trim Wrote:
This procedure does what you want for the activecell:

Sub Freeze()
ActiveCell.Formula = ActiveCell.Value
End Sub

HTH
--
Helen



Jeah! Great THX!


--
LL0rd
------------------------------------------------------------------------
LL0rd's Profile: http://www.excelforum.com/member.php...o&userid=23712
View this thread: http://www.excelforum.com/showthread...hreadid=373879