Like this :- ??
ActiveCell.Value = "<br" & ActiveCell.Formula & "<br"
--
BrianB
------------------------------------------------------------------------
BrianB's Profile:
http://www.excelforum.com/member.php...info&userid=55
View this thread:
http://www.excelforum.com/showthread...hreadid=373571