Can't unmerge merged cells programatically

J

James

Manually, I can unmerge some cells, say A1:C1. They have a formula
inside. I'd like to change the formula programatically. However, the
simple code
range("A1:C1:").select
Selection.MergeCells=False
doesnt' work.

Any ideas?
 
Top