How to use range property in macro code to access Excel cells
How to use range property in macro code to access excel cells: The Excel worksheet in Excel 2007 has 1048576 rows from 1 to 1048576 and 16384 columns named from 'A' to 'XFD' i. e. the first cell is designated as 'A1' in the first row and 'XFD1' is the last column in the first row. To access 'A1' using the range property you use the code:
Now if you wish place some text in cell 'A1', you write:
Range("A1")="Name" - to input 'Name'
Range ("B1")="Salary" - to input 'Salary'
Range("B2")=6000 - to input 6000 as number
In this way you can use the range property to input 'text' and numbers. Later we shall see how to use other properties to perform calculations.