View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] transferxxx@gmail.com is offline
external usenet poster
 
Posts: 31
Default add formula next to corresponding cells

I would like to add the following formula "=SUM(RC[1]:RC[2])" in cells
starting H2 to H10 next to cell G2:G10

row 10 can vary - i,e adding the following formula "=SUM(RC[1]:RC[2])"
in cells starting H2 to H100 next to cell G2:G100

Can any bod help

(i,e i would like to offset 1 column & add formula next to
corresponding cells.

Thxs