Thanks, it works nicely after a few modifications(just changed it so it
runs once/each sheet read in)
Btw, if you change the For each sh in worksheets to a counter For Ndx
to X
It produces a nice error I have never seen with XL before :)
(X is some pretermined maximum, like number of sheets etc)

One weird thing is that it only works on certain sheets, but doesnt
touch other sheets read in, all have similar formatting and "same" data
in.

Thank you once again and Happy Holidays.