
Kalpesh Agrawal
VBA Paste Special
We learned to Paste the data simply in the previous topic…Now let’s learn to Paste special.
In Excel, Paste special is a very important feature. You can paste Format, Only values, Colum widths, and Paste all the text except Borders.

Run the above code, and you will come to know exciting results.
Related: How to Record, Run and Save Macro
Related: Cell Referencing in VBA
Written by: Kalpesh Agrawal (Actuarial Intern- IIB)