3 Ways to Copy and Paste Cells

3 Ways to Copy and Paste Cells

What is Excel VBA

VBA stands for Visual Basic for Applications. Excel VBA is Microsoft is programming language for Excel and all the other Microsoft Office programs, like Word and PowerPoint. The Office suite programs all share a common programming language.

Why Use Excel VBA?

While users cannot directly manipulate the main Excel software through VBA, they can, however, master the art of making macros to optimize their time in Excel. There are two ways to make Excel macros.

The first method is to use the Macro Recorder. After activating the recorder, Excel will record all the steps a user makes and save it as a “process” known as a macro. When the user ends the recorder, this macro is saved and can be assigned to a button that will run the exact same process again when clicked. This method is relatively simple and requires no inherent knowledge of the VBA code.

Copy and Paste: The Most Common Excel

Copy and paste is probably one of the most common actions you take in Excel. It is also one of the most common tasks we automate when writing macros.

There are a few different ways to accomplish this task, and the macro recorder does not always give you the most efficient VBA code.

In the Following one Video I Explain and Code

1.The most efficient method for a simple copy and paste in VBA.

2.The easiest way to paste values.

3.How to use the PasteSpecial method for other paste types.

Example

Range("A1:A20")="Knowledge Education Cambodia"
Range("B1:B20")=Range("A1:A20").Value
Range("A1:A20").Copy
Range("E1:E20).PasteSpecial
Application.CutCopyMode=False
End Sub

Please Watching My Video is Below

Design by Vannak Vannaro