how or where can i get information on reading and writing information with individual cells in microsoft excel. i need to read information from some cells and write info to other cells.
thanks
Liam
Printable View
how or where can i get information on reading and writing information with individual cells in microsoft excel. i need to read information from some cells and write info to other cells.
thanks
Liam
A quick way is to:
Open Excel.
Ensure the Visual Basic toolbar is visible and select the Visual Basic Editor Button.
From within the visual basic editor select the help menu option and when the office assistant appears type cell in the box and search.
Look at the example for Cells property.
More searches reveals more examples.
There are 5 different method to refer to cells in Excel.
Range("A1").Value
Cells(1,1).Value
R1C1
Activecell.Value
[A1]