i'm using:

Range("c3").AutoFill Destination:=Range("c3", ActiveCell), Type:=xlFillValues

this works well for the autofill, but the formulas don't break (i.e., turn into values)...?

???

thank you.

I'm sorry you can't do what you want just with AutoFill.

You need to copy the results of the formulas you've just created with the auto fill and use something like PasteSpecial to replace the formulas with values.

ah...it sounded so nice...

So I added:

Range("a9:s9").AutoFill Destination:=Range("a9:s" & myrow), Type:=8
Range("a9", "s" & myrow).Copy
Range("a9", "s" & myrow).PasteSpecial xlPasteValues
Range("a9").Select



Seems to be working…any thoughts? Thank you.