Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have recorded a few macros successfully but now have to make som adjustements in the vba code. Specifically, I need to change the cel reference from A2 to C5 in my formula. In my VBA code, A2 appears a RC[-26]. What would the equivalent of C5 be in vba code format? T avoid future such problems, what is the rule/logic behind th translation of cell references of formulas into vba, i.e. why does A equal RC[-26]? Thank you for your help. Regards, Xlund -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to find #ref! invalid cell references within cell formula | Excel Worksheet Functions | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Dragging a formula with cell references | Excel Discussion (Misc queries) | |||
cell formula references | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel |