Fill Down Formulas Only (not formats)

[ryanmorris]

Using selection.autofill to fill a formula down a range. How do you fill the formulas down only without filling down formats? Can't find it anywhere on the net.

[tlafferty]

Sounds like you are using VBA. Assuming you want to use the SUM formula to add values in the A and B columns:

Please Login or Register  to view this content.

[ryanmorris]

This thread can be marked solved

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save