Page 408 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 2 : Using R1C1 Reference in VBA
Step 1: Open the workbook in Excel.

Step 2: Access VBA Editor: Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.

Step 3: Insert a Module
• In the VBA editor, ensure that your workbook is selected in the left Project Explorer window.

• If there isn’t an existing module, right-click on your workbook name, choose Insert, and then click on Module.

393
CITS : IT & ITES - Computer Software Application - Exercise 67 CITS : IT & ITES - Computer Software Application - Exercise 67