to access worksheet cells using cell property in an Excel macro
||Excel VBA Books
Cells(3, 1) = "Name"
Cells(3, 2) = "Salary"
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|