View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dhir dhir is offline
external usenet poster
 
Posts: 5
Default VBA code for Sum and diff

I want VBA Code for formula which is like this

The Formula is in loop
i value keep on changing in loop
Di=Ai+B(i-1)-C(i-2)

So in D10 then formula should be like this =A10+B9-C8

I don't want R1C1 Method


I am trying for last two weeks...

Regards
Dhir