sorting merged cells

[Guest]

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

 

[Alex Delamain]

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

 

[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