sorting merged cells

R

rondarusty

my worksheet cannot be sorted because it is saying that it cannot sort merged
cells, how do i find the merged cells bucause i see none
 
A

Alex Delamain

Select the whole area then Format, Cells, Alignment and make sure th
Merge celss box is clea
 
D

Don Guillett

try this or just select the cells button (top left of row/columns) and right
click>format>alingment>uncheck merge.

Sub findmerged()
For Each c In Selection
If c.MergeCells = True Then MsgBox c.Address
Next
End Sub
 
Top