I am looking for a simple macro that will umerge a cell and copy the value
in the original merged cell into all the cells created as a result of the
merge. Any suggestions?

Thanx,
--
Anil Gupte