Hello
Please help with this probably simple problem...
I'd like to sum a fixed range of cells in a VBA Macro and so tried the following:
Range("A15").Formula ="=Sum(A1:A14)"
This works but permanently adds the formula "=Sum(A1:A14)" into the cell A15, whereas as I just want the numerical result in the cell. (So that after the Macro has been run, if any values in A1:A14 are changed by the user the value in A15 remains the same)
What VBA code should I use please?
Thanks
Robin
Also, remember to post code via code tags...
Please Login or Register to view this content.
Highlight code and press #
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Or:
Please Login or Register to view this content.
Thanks, that works perfectly.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Tx for rep +
Or, if your range is truly "fixed" (meaning "unchanging") as you say in Message #1, then this will also work...
[A15] = [Sum(A1:A14)]
Last edited by Rick Rothstein; 04-28-2020 at 07:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks