Thread: Adding values stored at relative cell references
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tc tc is offline
external usenet poster
  
Posts: 40
Default Adding values stored at relative cell references
hi. i need to add values which are stored in cells with relative cell
references. for eg. ActiveCell.FormulaR1C1 = "=Sum(0.15*(RC[-3]-RC[-6])
+ H12" . Is this possible? and if it is, i would also like to know how
to change the reference to a row above or below. thanks in advance.
Reply With QuoteReply With Quote