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.

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?