Help...User cannot sort MERGED CELL ISSUE.....

M

mniccole

Hi:
After my user tries to sort the excel sheet my macro created, the
following error is displayed:

The operation requires the merged cells to be identically sized.
Isn't there something that will fix this?
I tried this but it doesn't seem to work.

Thanks...

Worksheets("BillingHoldDetails").Select
ActiveSheet.Columns.AutoFit
'ActiveSheet.Name = "BillingHoldDetails"
Prng = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row

'Range("A1:N3000").Sort key1:=Range("B2"), Order1:=xlAscending
Intersect(ActiveSheet.UsedRange, Range("BillingHoldDetails!C1:N" &
Prng)).Select
Selection.Subtotal GroupBy:=1, Function:=xlSum,
TotalList:=Array(11), _
Replace:=False, PageBreaks:=True, SummaryBelowData:=True
Worksheets("Menu").Select
 
Top