When generating a formula for a given cell through VBA, I need to be able to
combine a relative reference (of form of R[x]C[y]) and an address retrieved
from a different sheet (of form Sheet1!A12). When the VBA accomplishes this,
the cell reference is invariably returned as a literal value: 'A12' and no
longer functions as a cell reference. This seems new to Excel 2003 and is
extremely unhelpful. However, any VBA coding I made in Excel 2000 with
exactly this form of coding still functions properly. Can anyone advise me?