Hi! Doing some automation in Excel.

Want to put a sum into a cell from cell say C3 to AB3?

The columns increase or decrease depending on how many products are selected in Foxpro,

Q: How do I do a SUM command using cells references rather than cell names ie CELL(3,3) not A3

or can I work out the name (A3) from the cell reference?

HTMS

TIA

Robin