Posts by trunten

    something like this maybe?

    make sure you try it on a copy first as it's a destructive process. :)

    In Microsoft's ever increasing attempts of sabotage on my previously working code, I've moved to a 64bit machine that completely breaks my above code. I've made an update to the class that should now work regardless. Usage examples remain unchanged.

    Class code:

    As before, class file attached with whitespace prerserved (remove .txt and import into vba)

    my solution