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.
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.
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.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
This thread can be marked solved
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks