Returns the contents of the upper-left cell in the range as a string.
theContents = Range.getCellContents()
Use getCellContents if you want to retrieve the formula from a cell, rather than the value to which the formula evaluates.
See also
getCellValueAsNumber method
getCellValueAsstring method
setCellContentsFromNumber method
setCellContentsFromstring method