Is there a default for 'no formatting' with autofill?

Hello -

I'm creating a worksheet to be used by 200+ individuals w/varying versions of excel. Is there a way to set the default of autofill, such that it automatically autofills w/o formatting? My template uses conditional formatting to create alternate colored rows, but when autofill is used the color formats fill as well.

Thanks for any help!

Hi bbexcel,
Your post was a long time ago.But if still need this...
.range("A1").autofill destination:=.range("A1:A10") , type:= xlFillValues