Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

Copy and paste a range

Think you have below values in "Sheet1" of your excel workbook. And you want to just copy paste them to similar cells of the "Sheet2". You can do it with one line of code.

Below code will copy values of cells from "A2" to "E2" of sheet1 to same cells of sheet2.


Worksheets("sheet1").Range("A2:E2").Copy Destination:=Worksheets("sheet2").Range("A2")

Contact Form

Name

Email *

Message *