Found these other topics that discuss the same question for some further reading…
How to read a value from a cell
possible to access cell values and context values of cell ??
How to loop the cells of a report via VBA script ?
VBA code to access the cell values in cross tab
Dave Rathbun 
(BOB member since 2002-06-06)