| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address Referencing
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a cell address in the Offset formla | Excel Worksheet Functions | |||
| Referencing the same cell address while copying a formula | Excel Worksheet Functions | |||
| referencing cell address | Excel Programming | |||
| referencing a checkbox cell address in a worksheet | Excel Programming | |||
| LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming | |||
Threaded Mode
