Formulas in Excel

[Mark]

I want to make a formula follow down the length of the
column. the formula is easy it just in cell E3 =C3*D3.
and i want the cell E4 to =C4*D4. and follow down. if
anyone can help i would appreciate it. Thanks
Mark

 

[Don Guillett]

modify to suit

Sub balance()
Set frng = Range("e3:3" & Range("c65536").End(xlUp).Row)
With frng
.Formula = "=c3*d3"
' .Formula = .Value 'changes to values afterwards
End With
End Sub

 

[Rick C]

Mark,
Based on your question, I'm guessing that Don's response is a little
advanced. Please forgive me if I am assuming too much, but you seem to be
looking for an easier solution.

Just copy cell E3 and paste it onto cell E4. You can also select the entire
column and paste it. The cell references will update accordingly. Look up
absolute and relative references in Excel Help for more info.

HTH,
Rick

 

[Ken Wright]

Click into cell E3, then hover the mouse over the bottom right hand corner of the cell, click onto
the little black cross and drag down across the range you want to fill.

 

[Nigel Graham]

As in Ken's solution but instead of dragging down just double click the
little square in the bottom right corner and the formula will go all the way
to the bottom. Only problem is that if you have a gap in the data it stops
at the first black reference cell. Simple is quickest and if you have
65,000 sets of data my method takes seconds. Hope this helps.
Nigel Graham
Hutton IT
www.hit.uk.net

 

[Don Guillett]

See, Ken did it.

It would be, but Mark's question leads me to believe he is a novice.
Explaining the fill handle to a novice through email could make someone's
head explode...probably mine. ;-)