Error with Code

[Tom22]

Hi Guys,

I am trying to add this code to work book but it is showing error that variable not defined at For each sheet in sheets line.

Not able to solve this puzzle, can anyone plz help here?

Attaching test file for reference.

Thanks,
Tom

 

[vletm]

Tom22
As You're using text Option Explicit.
You've to declare sheet variable.
eg by writing Dim sheet before On Error Resume Next

 

[Tom22]

Thank you very much...it's working now