If the formula is not already in C2, then

Sub EstablishFormula()
Dim rng as Range
set rng = Range(cells(2,1),cells(rows.count,1).End(xlup))
rng.offset(0,2).Formula = "=A2+B2"
End Sub

--
Regards,
Tom Ogilvy

"bay" wrote in message
...
Hi

I am a total newbie in programming so this might seem an easy question,
still needs an answer though.

I am tring to set up macros for certain tasks. I have a list in a sheet
with
row 1 being the headers, and the data from row 2 to row 100. What I need
to
do is copy a formula (ie =A2+B2) in column C, from c2 to c100. Because i
need
to use this macro on other sheets as well that have lets say 150, or 200
rows
I need the macro to "understand" and copy the formula only down to where
the
list ends, (ie the last non-blank cell of column A)

Any ideas?

Thank you,

bay