Calculating a Block of Formulas
I have some formulas that are nested in cells A1:F100 that will not calculate with the conventional automatic calculation setting since they are referring to a homemade dll.
The only way the formulas will calculate is if you re-enter each formula over top of the cell. I am wondering if, programmatically, one could say activecell.value = activecell.value.
What would be the most efficient way of calculating these formulas?
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
I'd be interested in seeing if a single instance of
would do the trick.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
sometimes adding rand()*0 to the end does the trick. ="your custom formula(a1)"+rand()*0
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That's assuming the formulas have a numeric output. For string outputs, this is a slight alteration on Martin's suggestion to make the formula volatile:
="your custom formula(a1)"&REPT("",RAND()*0)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks