Autofill

[kapi98]

Hi there,

I was just just wondering if three's way to make Excel to only autofill the calls in a range that contain a formula.

At the moment, I'm using this code which obviously doesn't support this functionality.

Range("W6").Select
    Selection.AutoFill Destination:=Range("W6:W51"), Type:=xlFillValues

Thanks