First, is there any way to make the program pause 1 second before continuing to calculate? I can do it in excel but can't figure out how to do it here. I'm reasonably familiar with VBA.
Also, all of my worksheets have the maximum of 65,536 rows. No matter how many I delete, it remains at 65,536. This happens in a brand new worksheet with no code as well. I only need a few hundred rows or less on these sheets.