Thread: Formula
View Single Post
  #5   Report Post  
PY & Associates
 
Posts: n/a
Default

Is this alright?

for i = 1 to NrOfRows
cells(i, AnsCol)=function(cells(i,VarCol))
next i

"V" wrote in message
...
I need to create an excel spreadsheet using a math equation that has one
variable that is the denominator of a fraction. I need to be able to

change
the variable every row. Ie - starting variable is 3 and last variable is
101. Any tips would be greatly appreciated!! Thank you