Excel VBA: Cell Reference in Another Sheet - 4 Methods

This is the sample data set.

Method 1- Reference Cells in Another Sheet with Excel VBA

Copy the data in D5 in ‘Sheet2’ to ‘Sheet1’

Step 1:

Press Alt + F11 to open VBA.
Click Insert.
Choose Module.

Step 2:

Enter the following VBA.

Sub Select_a_Cell()
    Worksheets("sheet1").Range("D5").Copy
End Sub

Step 3:

Save and press F5 to run the code.
D5 is copied in ‘Sheet1’.

Method 2 – Reference Cells for Multiple Ranges in another Sheet with Excel VBA

Step 1:

Select Module and enter the following VBA.

Sub Copy_Ranges()
    Worksheets("sheet3").Range("B4:F11").Copy
End Sub

Step 2:

Save and press F5 to run the code.
B4:F11 is copied.

Step 3:

Enter the following code.

Sub Copy_Multiple_Ranges()
    Worksheets("sheet3").Range("B4:F11,B13:F16").Copy
End Sub

B4:F11 and B13:F16 are selected and copied.

Method 3 – Reference Cells in Another Sheet with Excel VBA

Copy B2:F11 from ‘Sheet4’ and paste it in ‘Sheet5’.

Step 1:

Select Module and enter the following VBA:

Sub Paste_Multiple_Ranges()
    Sheets("Sheet4").Range("B2:F11").Copy
Sheets("Sheet5").Range("B2:F11").PasteSpecial
End Sub

Step 2:

Save and press F5 to run the code.

The range in ‘Sheet4’ will be pasted in ‘Sheet5’.

Method 4 – Reference Cells in Another Workbook with Excel VBA

Copy the data in the ‘Fill Blank Cells’ workbook and the ‘VBA’worksheet. Paste it in ‘Sheet7’ of ‘Cell Reference’, the current workbook.

Step 1:

Select Module and enter the following VBA.

Sub Copy_from_Another_Workbook_1()
    Workbooks("Fill Blank Cells.xlsm").Worksheets("VBA").Range("B4:F14").Copy
    Sheets("Sheet7").Range("B4:F14").PasteSpecial
End Sub