Macro to run all sheets is getting stuck in a loop

[Christopher135]

Hi guys,

I've got this here peice of code

Please Login or Register  to view this content.

The macro is supposed to run on all sheets (305 of them), and as is obvious, auto fit all the columns, clean up some of the data in column K (phone numbers, some of which prefixes/suffixes I want removed) and then add the count formula to N2 and O2 (counting phone calls between 10-20 mins, and phone calls in excess of 20+)

The code works when I remove the "for all sh" and run it on an individual sheet. When I try to run the code above, it gets stuck in a loop, repeatedly adding 2 new rows to the first sheet only.

Most of this is a recorded macro, and I'm not very VBA literate, so I'm not sure what I've done wrong here?

Thanks guys!

[stnkynts]

The reason it is only working on one sheet is because you didn't declare the sheet (sh) for each range so it just picks the range from the active sheet over and over again.

Edit: Untested but try this:

Please Login or Register  to view this content.

[Christopher135]

Thanks so much for the help! I knew I was missing something silly!

After you pointed out my error, I tried your code which works, and also figured out that if I add

Please Login or Register  to view this content.

at the start and

Please Login or Register  to view this content.

it also works! Thanks for helping me with new code and finding my mistake

Cheers!