Sorting each worksheet in a workbook

[irfanparbatani]

Hello Friends

I have this piece of code which i use for sorting, there are two different range on the same worksheet which needs to be sorted and I need to loop through all the worksheet. But it only sorts the current worksheet where I start running the macro. The range to be sorted is same for all worksheet.

Code is below:

Please Login or Register  to view this content.

Can anyone help me for sorting for every worksheet in a workbook?

Response would be appreciated.

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[irfanparbatani]

Hello Jerry

The above code works fine , but the only problem is it does not sort the last worksheet in the workbook. Could you please suggest what needs to be done.

Aprreciated.

[JBeaucaire]

Remove the - 1 from the FOR... line of code.


If that takes care of your need,
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

[irfanparbatani]

Thanks Jerry for your quick response.

Appreciated mate.