Improvisation of code to run in all worksheets of a workbook

[VKS]

Dear Experts,
I have found the below code after lot of search that solves my problem. In its current form it runs on one sheet at a time ( I have 50 plus sheets).
Help I need it to modify it in such a way that it runs on all the worksheets of the active workbook.
Please help help/advise…..
Best Regards/VKS

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[VKS]

Hello AB,
Coming here after long time and very happy to see you as Forum Guru……
Running the code I get this msg “ Run time error 91” Object variable or with block variable not set
Best Regards/VKS

[AB33]

There are a couple of lines missing. Since I do not have any data to test it, you need to tell me in which line do you get the error?

Please Login or Register  to view this content.

[VKS]

Hello AB, No more error messages but only sheet one is getting updated with the code below not all

Please Login or Register  to view this content.

[AB33]

VKS,
Okay, the best way to test why the code acts on a single sheet is to step over the code using F8 (Using step by step) and see if the code first loops through all sheets. If it does then, which sheet does the code acts on and ignores the rest.
I suspect the code probably find match only on a single sheet.

[VKS]

Will do and let you know tomorrow. If I face the same issue then I will add a sample file also not 50 but 3 or 4 sheets.
Though structure of the sheets is same with only difference Analysis 1 and Analysis 2 may appear on different rows in each sheet.
Thanks for your efforts so far
Best Regards/VKS

[AB33]

VKS,
The row numbers do not matter as long as you are searching in column A.

[VKS]

Hello AB,
Both your codes are working great but I cant figure out why they don’t work if I run them from personal macro file but they work fine when pasted in the workbook. Discovered this while making a sample book to share as I couldn’t get them running from a module in personal file since yesterday.
Best Regards/VKS

[AB33]

VKS,
I am not surprised you can not run the code from personal workbook. Let' say, I have my personal workbook open, but not sheets, how do you loop through sheet's collection? Even if you have sheets, the loop will work with the sheets in the personal workbook, not your actual book.

Try

For Each ws In activeWorkbook.worksheets
and make sure that the cursor is on the active sheet work book you are trying to work on before you run the code.

[VKS]

Thanks AB, You have been a great help and have my star.
Best Regards/VKS