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)