sort issue?

[zabiullakhan]

i have this code for sorting, however it gives me an error

"This operation requires the merged cells to be of identical size"

this error is due to few merged cells on my sheethow can i avoide this error as i need this merged cells.

Selection.Sort Key1:=Range("B1"), Order1:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Please help

 

[Peter_SSs]

The sorts of options that come to mind are

- Get rid of the merged cells and see if 'Center Across Selection' would do just as well.

- Merge all the (groups of) cells in the sort range so they are all identically sized.

- Unmerge, sort, re-merge.

If you cannot make something of that, then you may need to provide more detail about just what you have on your sheet, where it is, which cells are merged and why you *need* the merged cells.

 

[zabiullakhan]

How can i do unmerg and re-merge as i have merged no of blocks of cells.

 

[Peter_SSs]

How can i do unmerg and re-merge as i have merged no of blocks of cells.

I don't know if that will be applicable to your circumstances since I don't know what your circumstances are.

As I indicated in my previous post, if you couldn't make something of my suggestion yourself, you would have to provide certain additional details.

 

[zabiullakhan]

- Unmerge, sort, re-merge.

I think your above suggestion would work where in i can unmerge all the cells in a work sheet then sort and re-merge the cells as before.

as my sort code is as below

Selection.Sort Key1:=Range("B1"), Order1:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

how can i do un merge and re merge

 

[Peter_SSs]

I'm sorry, but I'm afraid that since you seem unprepared to provide the detail I asked for, I am unable to provide the detail of any code.

The only other thing I can suggest is to use the macro recoder to unmerge your cells, sort, and re merge the relevant cells and see if you can work with that code.