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