Skip to main content

All Questions

0 votes
1 answer
64 views

Adding extra functionality/logic to an Excel Spreadsheet

I am new to Excel functions and VBA programming, so this problem has been a real challenge for me. I have a spreadsheet that keeps track of the status of applications in 64bit testing that I would ...
GhostType's user avatar
0 votes
1 answer
114 views

How to Lock In Excel References

I'm working on correcting these large two excel sheets. I need the sequence of entries to match up and I need to make sure they both have all of the same entries. To check for this I created two ...
CGTheLegend's user avatar
33 votes
9 answers
15k views

Limit Excel CPU Usage

Is there a way to limit how much CPU usage excel has access to when running? I have a VBA script that calculates a bunch of giant array formulas. The entire calculation takes maybe 20 minutes using ...
learningAsIGo's user avatar