Working with a specific cell

To refer to a specific cell within the spreadsheet, use the Range object as follows:

Range("a1")

This is equivalent to the ActiveCell in terms of it's properties and methods, so all of the following are valid:

Range("a1").Value

Range("a1").Formula

Range("a1").Cut()