troubleshooting Question

Copy, export or print results from Evaluate Formula box in Excel

Avatar of WeThotUWasAToad
WeThotUWasAToad asked on
Microsoft Excel
5 Comments4 Solutions409 ViewsLast Modified:
Hello,

Is there a way to acquire the information displayed in the Evaluate Formula box in Excel?

Sometimes, when evaluating a large or complex formula, the evaluation results displayed in the Evaluate Formula box is lengthy and requires scrolling to view in its entirety as shown in this example:



That, combined with the possibility of having multiple portions to evaluate, can make the process of understanding a particular formula quite cumbersome.

In the past I have typed out the displayed evaluation results by hand but that is a lengthy task and prone to errors and therefore not a good solution — especially for large or complex formulas.

I have tried (by mouse and keyboard) to select the evaluation results in order to Copy/Paste them into a Notepad file. I have also tried Right-clicking and anything else I could think of but without success.

If there is a way to capture evaluation results from the Evaluate Formula box — even if doing so is not possible directly in Excel but requires VBA, I would appreciate knowing how to do it.

Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 4 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros