copying formula from one cell to a range
 

I need to fill a range of cells with a relative formula. What I'm
looking for is something like this:

sheet.range.formula = sheet.cells.formula

I know one can copy formula from one cell to another, and from one
range to another (if dimensions are identical). But how does one
copy formula for one cell to a range? Any help is highly appreciated.

copying formula from one cell to a range
 

John Smith wrote:
I need to fill a range of cells with a relative formula. What I'm
looking for is something like this:

sheet.range.formula = sheet.cells.formula

I know one can copy formula from one cell to another, and from one
range to another (if dimensions are identical). But how does one
copy formula for one cell to a range? Any help is highly appreciated.

How about copy the formula, selct the range and then paste?