Can't unmerge merged cells programatically

  • Thread starter Thread starter James
  • Start date Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merged Cells Question 4
vb code to clearcontents of a merged cell 8
macro to unmerge cells 6
Range.Delete Shift causing merged cells to unmerge 4
Unmerge cells and fill duplicate data 5
MACRO - Unmerge cells and delete blank columns, leaving data colum 5
How can I unmerge the merged cells in a Excel sheet quickly? 9
Macro to Save (As) a file 5

Back
Top