Sort using VBA

[YasserKhalil]

Hello
I have the folowing code that sort data

But it is by macro recording .. I want to do it in a profssional way

Please Login or Register  to view this content.

[naveenmarapaka]

Hi
Try

Please Login or Register  to view this content.

[YasserKhalil]

I tried it but got this error

Run time error 1004
Select method of Range calss failed

[YasserKhalil]

I want to know how to do the sort in vba .. need to summariaze the long code in two or three lines

[YasserKhalil]

I tried to put this part in a separated module
but I go this error
1004
The operation requires the merged cells to be identically sized

I don't have any merged cells!!!!!!!!!

[alansidman]

Suppose you upload a sample file so that we can provide you with code that works in your example. It is difficult to determine what is driving your issues without seeing the entire picture.

[YasserKhalil]

I have discovered a merged cell and I got rid of the problem
Thank you very much for your help