Posts by Matt Heldman

    Re: VBA: Paste Special (Values)


    I got this to work. It's cleaner and faster. But if I highlight and clear multiple cells or press delete it does not erase it from the second sheet. I can live with that but if anyone has any tips to do make deleting multiple cells work, that would be great.


    This version goes in the CS Scale sheet and a reverse sheet order goes in the RS Scale sheet. Works great.





    Re: VBA: Paste Special (Values)


    This works great except for one thing. It duplicates conditional formating every time it copies. Is there a way to make it "paste special values" and leave the rest alone?