Caution Writing PasteSpecial Macros

Caution Writing PasteSpecial Macros

One day I was teaching a co-worker how to create simple macros to use across any of his workbooks.  I like to refer to these kinds of procedures as Personal Macros.  We were messing around with the PasteSpecial functionality by trying to Paste Values Only and Paste Column Widths simultaneously.  The simple code looked something like below.

Read More