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()