Worksheet Looping not working for all the sheets

Hi All,

I am trying to run below Macro for several worksheets in a workbook (For an instance, lets assume 3 sheets)

Though the initial sorting part is getting executed for all the three worksheets but rest of code is not.

Please suggest what changes need to be carried out in the code below so as to make it worksheets friendly/usable.

Code :
----------------------------------------------------------------------------

Please Login or Register  to view this content.

--------------------------------------------------------------------

Let me guess, the second half of the code is only being executed in the first sheet but not the rest

Hi Blue_kul, can you provide a mock workbook with some non-sensitive data for us to work with?

I think you need to declare what sheet is being worked on regarding your code. Try:

Please Login or Register  to view this content.

and let us know how it goes.

here it is, first sheet shows the desired result but not working on rest of two sheets

Test File.xlsm

From a quick look at your code, you are looping correctly through the worksheets, but the problem is that the focus of the second part of the code never moved from the first sheet. The way I would normally do this is to use:

Please Login or Register  to view this content.

but that also means that you have to put a period before every range [e.g. .Range("A1") or .Cells(1, 1)].

Or you can activate each worksheet at the begining of the loop:

Please Login or Register  to view this content.

abousetta

Hi Andrew,

I agree that activating, selecting, etc. is a waste of time but it is a valid option especially for a novice who might not be able to spot every range object (especially if the code is snippets borrowed from online pieces of code). It took me some time and effort to learn how to improve code efficiency and it's not always clear which lines of code can be/ should be ommited or condensed.

Hi,

Glad it all worked out. You can mark it as [SOLVED] by going to the original post (#1) --> Go Advanced --> and change the prefix to [SOLVED]. Details should be avaialble in the forum rules.

Best of luck.

abousetta