Hi Again!

Thanks for the response. After I posted this I was tinkering around with it
and I got it to work using this code:

Worksheet("Sheet1").Range("C2:C100").FillDown

I assume it does the same thing as what you posted?

"Dave Peterson" wrote:

range("C3:c100").formula = range("C2").formula

or
range("C2").autofill _
destination:=range("C2:C100")

Secret Squirrel wrote:

I have a formula in cell C2. I want to create a macro in VBA to fill down
that formula into cells C3:C100. How would I write that code?

--

Dave Peterson