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?

I'm not sure what you're after, but perhaps the following will shed some
light:

Range("C10").Formula = Application.ConvertFormula("=R[-1]C[-2]", _
xlR1C1, xlA1, , relativeto:=ActiveCell) & _
"+" & Range("F1").Address(False, False)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"In10sJP" <(E-Mail Removed)> wrote in message
news:7ADB8C31-222B-44D3-86C7-(E-Mail Removed)...
> 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?