CellValue Method
The CellValue method returns the raw data value in a column for the row specified by the bookmark argument.
column.CellValue(bookmark)
Arguments
bookmark is a variant representing a control row.
Return Value
A variant containing the underlying data value for the specified row.
Method applies to Column object.
Using the CellValue method is similar to accessing the Value property, except that you can select a specific row from which to retrieve the value.
Using the CellValue method to extract information from a cell doesn't affect the current selection.
Use the CellText method to access the formatted data value for the specified row.
See Also