Sorting specific group of cells in all Worksheets

[n_malley]

Hi All,

I have a Marco to sort columns B-E from row 5 down to 700, i want this to happen on each worksheet in the workbook (currently 45 but more might be added)
I have been trying to edit the code to apply to all worksheet as it was only set to one, but it doesn't seem to be working, any help would be fantastic.

Please Login or Register  to view this content.

thanks guys!!
(still new the forum so apologies if i broke any rules!)

[nilem]

Hi n_malley,
maybe so

Please Login or Register  to view this content.

[n_malley]

Hi n_malley,
maybe so

Please Login or Register  to view this content.

Hi Nilem,

thanks for the reply the code sorts perfectly but i throws up error "this operation requires the merged cells to be identically sized" is there any way i can stop this?
thanks

[nilem]

If you do not need merged cells, then

Please Login or Register  to view this content.

[n_malley]

Thank you
massive help to my project!