Checking for merged cells

D

dhstein

Is there a way in VBA to loop through a range, check if any of the cells are
formatted as merged cells and if so, display a message? Thanks.
 
M

Mike H

Hi,

Like this maybe

Sub MergedCells()
Dim c As Range
For Each c In ActiveSheet.UsedRange
If c.MergeCells Then
MsgBox c.Address & " is merged"
End If
Next
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

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

Sharing workbooks limitations - Merged Cells 12
VBA set thick borders around non empty cells in range 0
Count with merged cells 2
sorting two columns of merged cells 1
Automatically color merged cells 1
Link Merged Cells 3
How do I locate merged cells in my Excel worksheet? 7
Trailing Spaces in Merged Cells 1

Top