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