Merged Cells

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hello

How can I find out if a range contains merged cells? I think that it is not
very powerful to check each cell if the MergeCells property is true? Any
faster ideas?

Many thanks in advance.

Tom
 
Tom,

Cell by cell is the only way. AFAIK. A better solution is to never use merged cells.

HTH,
Bernie
MS Excel MVP
 

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

VBA set thick borders around non empty cells in range 0
merge cells 2
Merged Cells Autofit Macro Code 1
Modify Recorded Macro 1
How do I select a range to merge cells? 5
RowHeight and AutoFit wit Merged Cells 34
Auto fit wrapped and merged cells in entire worksheet Options 0
Text not looping through ranges 10

Back
Top