Confused? I am. Why not send me a copy of the workbook directly.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Renegade Snail " wrote in
message ...
When i run the macro the formula is deleted and the cell contents are
replaced with this text:
"#VALUE!"
hope that helps
---
Message posted from http://www.ExcelForum.com/