Hi I am using the SumIfBold to add some cells in a range.
How can i return the total that the SumIfBold has calculated in my worksheet at a defined range such as Range("NetTotal")?
Thanks
Please Login or Register to view this content.
Hi I am using the SumIfBold to add some cells in a range.
How can i return the total that the SumIfBold has calculated in my worksheet at a defined range such as Range("NetTotal")?
Thanks
Please Login or Register to view this content.
Last edited by ashmott; 08-26-2011 at 02:49 AM.
The following works for me:
Please Login or Register to view this content.
Oh, a word of warning - changing fonts does not trigger a sheet recalculation, so even if you make the function above volatile it will not recalculate when you change cells to or from bold.
You will either have to manually re-calculate, or call a re-calculation from, maybe, the selection change event.
Thanks Andrew.
If I want to display the sum at say cell(A1) could I use the following or something else. I basically need to display the sum at range(A1).
Thanks
Please Login or Register to view this content.
You can use it either as worksheet function :- so in cell A1 you could put:
Please Login or Register to view this content.
Or you can use it in a macro:
Please Login or Register to view this content.
The code offered here, returns error >>> NAME? Is it becuase I use a newer version of excel?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I added the code, and save it as a macro enabled file. may be I misspelled the formula, but is it a case sensitive?
No case sensitivity is not an issue
It worked thanks a lot
The function Rounds the final result, is it possible to remove the rounding ? I looked through the code but could not identified what to change
Instead of Long change it to Double
Please Login or Register to view this content.
Thank, I was only changing Dim lTempCount As Double.
Thank you...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks