Detect merged cells in VBA Excel with MergeArea

by

There are several helpful bits of code for this.

Place your cursor in a merged cell and ask these questions in the Immidiate Window:

Is the activecell a merged cell?

? Activecell.Mergecells
 True

How many cells are merged?

? Activecell.MergeArea.Cells.Count
 2

How many columns are merged?

? Activecell.MergeArea.Columns.Count
 2

How many rows are merged?

? Activecell.MergeArea.Rows.Count
  1

What’s the merged range address?

? activecell.MergeArea.Address
  $F$2:$F$3

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. Refer to sheet using codename
  4. VBA macro that search for file in multiple subfolders
  5. VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Last not empty cell (column) in the given row; Excel VBA
  8. Getting ScriptControl to work with Excel 2010 x64
  9. Application.Match gives type mismatch
  10. Count and Highlight keywords within phrases
  11. Transpose a range in VBA
  12. Protecting cells in Excel but allow these to be modified by VBA script
  13. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  14. How to “flatten” or “collapse” a 2D Excel table into 1D?
  15. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  16. Excel VBA: AutoFill Multiple Cells with Formulas
  17. VBA.Find and adding a value
  18. excel vba- extract text between 2 characters
  19. VBA – How the colon `:` works in VBA code with condition
  20. Round function in Excel, worksheet function vs VBA
  21. How to continue the code on the next line in VBA
  22. Excel VBA Userform – Execute Sub when something changes
  23. Count the number of rows in another sheet [duplicate]
  24. Getting Excel to refresh data on sheet from within VBA
  25. How can I generate GUIDs in Excel?
  26. VBA Password Input with Cancel Function
  27. Finding first blank row, then writing to it
  28. How can an Excel Add-In respond to events in any worksheet?
  29. VBA inheritance, analog of super
  30. How to wait until ActiveWorkbook.RefreshAll finishes before executing more code

Leave a Comment