View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Smith John Smith is offline
external usenet poster
 
Posts: 62
Default 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.