Can't unmerge merged cells programatically
 

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?

Can't unmerge merged cells programatically
 

James,

Range("A1:C1:").UnMerge

Regards,
Jim Cone
San Francisco, CA

"James" wrote in message ...
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?