How
to access worksheet cells using cell property in an Excel macro
- Click on the developer tab
- Select Visual Basic from the Code group
- In the new Microsoft Visual basic window that pops-up select insert fom the menu-bar
- Click on module
- You get a workspace to write the code which is given below
Cells(3, 1) = "Name"
Cells(3, 2) = "Salary"
End Sub
We have also shown how to view the Excel worksheet in the 'R1C1' style where the columns and the rows are both numbered starting from 1, 2, etc. This will also give you an idea on how the application works in this mode. Now A3 is R3C1 as shown in the 'name box'. Just observe carefully!
- Click on the Microsoft Office Button
- Select Excel Options at the bottom right
- In the Excel Options Window that pops up select formulas and under 'working with formulas' check the box next to 'R1C1 reference style'
- Now your worksheet shows the columns asl with numbers 1, 2,
etc.