View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Xlund[_4_] Xlund[_4_] is offline
external usenet poster
 
Posts: 1
Default How to interpret cell references from formula to vba?

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