I've written some VB 6.0 code that opens an Excel document (Office 2003) and
then gets the data from the used cells and then sends that data to be
processed.

The problem I am having is that I am using the UsedRange.FormulaR1C1
property to get the cell info. I really need to map that data back to it's
true Row and Column but cannot find a way to do it. So I need the data in
the cell, row and column. I can't see anyway how to get at it. :-) I've
set a watch and expanded the tree to look at my document and just cannot see
an easy way to do this.

Is there anyway to get the data in the cells without having to loop through
the cells collection?

Any help would be appreciated.
Thanks,
David