autofill vba code not working

**ammartino44** · 04-29-2015, 06:21 PM

Hello. Why does this code not work?

Range("C29").Select
    Selection.Formula = "=C12*C3"
    Selection.AutoFill Destination:=Range("C29:O35"), Type:=xlFillDefault

**Philb1** · 04-29-2015, 07:10 PM

Most likely because the selection refers to one cell. Use this instead

Range("C29:O35").Formula = "=C12*C3"

**TMS** · 04-29-2015, 07:58 PM

Seems like this has already been answered.

http://www.excelforum.com/excel-prog...ficiently.html

Please don't duplicate posts.

Regards, TMS

Re: autofill vba code not working