View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
solo_razor[_13_] solo_razor[_13_] is offline
external usenet poster
 
Posts: 1
Default assigning a formule to each cel in a column

hello,

I have a problem, i want to assign every cell from 1 to 200 from a
certain column with a formule that calculates one cel minus another.
E.G.

cel f2 contains 20
cel g2 contains 34
cel h2 must than contain a formula =sum(f2-g2)
The formula self is not difficult using the macro recorder, but i want
to use one formula for an entire column

Regards,
Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/