Finding Merged Cells

ammdumas

Active Member
Joined
Mar 14, 2002
Messages
469
I figure somebody has done this before and has a macros handy...

I need to find all merged cells in a spreadsheet. Unfortunately I can't do any sort of global un-merge because the data is mixed, so I just have to identify the cells and then play with them manually. Finding them first would save a ton of time since there is about 4000 records using 25-odd columns. I guess putting the results in a separate cell or something (listing the cell numbers?) would be cool. Any help is appreciated. :ROFLMAO:
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
This will highlight merged cells yellow.

Code:
Sub FOrmatMergedCells()
Dim MrgCell As Range

For Each MrgCell In ActiveSheet.UsedRange
If MrgCell.MergeCells Then MrgCell.Interior.Color = vbYellow
Next MrgCell

End Sub
 

Forum statistics

Threads
1,148,050
Messages
5,744,513
Members
423,881
Latest member
Nguyen Vu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top