Question

Excel VBA: Create a macro that copies the cells and pastes to C column. Add a command button to start the procedure.

Answer 1

Macro to copy the celland paste to column c:

Range("A1").Copy Range("C1")

===================================

To add a command button, please follow the below steps:

1). GoTo Developer tab

2). Press insert button

3). Select the Button Form Control from the menu.

4). Right click and hold the mouse then drag and release to create your button.

5). The Assign Macro window will pop up and you can select the VBA procedure you want to run from the button.

6). Press the OK button.

I hope I anwered your question.