

How
to access worksheet cells using cell property in an Excel macro


Excel
2007 
Excel
2003 
Home 
Macros
Excel 2003 
Excel
2010 
About
Us 
Free
Ebook 
Offline
Training 
Blog 
Excel VBA Books 

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!




Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
About Us  Free Ebook  Offline Training  Blog  Excel VBA Books 