Hi guys,

This is a follow-on to the great subroutines by Peter T and Dana DeLouis to
my recent post " Transcribing cell formulas into their comment boxes"
at: http://tinyurl.com/7xumg which transfer a selected range's cell formulas
(if any) as text into their comment boxes. Cells w/o formulas (if any) would
have the phrase "No Formula" written into their comment boxes.

I would now like a sub to do the reverse action, i.e. write-back the
formulas from a selected range's comment boxes into the underlying cells,
overwriting cell contents, if any. And for cells with "No Formula" written
into their comment boxes (if any) -to take no action.

Any insights appreciated. Thanks.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----