Issue with loop

[SIMBAtheCAT]

Hi,

I have an issue with my loop. It doesn't loop through the sheets and stays on the activesheet. I think the problem is coming from the code I have highlighted in red. However, I'm short on ideas on how to correct the situation.

Please Login or Register  to view this content.

[Miraun]

You need to add in a
WS.Activate
before the rng = activesheet.usedrange

Or potentially change it to ws.usedranged... but not sure offhand

[AB33]

Please Login or Register  to view this content.

[Norie]

No need to use ActiveSheet or Activate, you just need to tell VBA which sheet you want the UsedRange of.

In this case that's the current worksheet in the loop, ws.

Please Login or Register  to view this content.

PS Be careful where you use On Error Resume Next, in this code I wouldn't use it's probably not needed anywhere

[SIMBAtheCAT]

AB33 & Norie, your ideas are the same but have a different formulation.

Thank you, it both worked.