| Another excellent way to access cells in Excel worksheets is to use the 'Cells' property. The cells property defines the row and the column index. Cells(1,1) means the cell in row 1 and column 1 of the Excel spreadsheet. In standar terms it means 'A1'. Once the cell has been accessed you can define whether you wish to input text (string), numbers, currency, formulas or functions into the excel cell. The cells property is very useful when you automate your calculations in Excel using a 'do while' or 'for next' loop. |