Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 99451 times)

Offline cgr

  • Dansdeals Gold Elite
  • ***
  • Join Date: Aug 2017
  • Posts: 162
  • Total likes: 10
  • Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1350 on: January 12, 2020, 12:34:30 PM »
Would it help if you slow down the code? I've seen something similar from John Walkenbach where his code was running faster than the shell object was able to process, so he had a do until loop check every second if it was ready to proceed.

Also just curious why you first used the sheets collection and then the worksheets collection

Thanks but I tried slowing down the code. Didn't help with the memory issue.

I pasted a few parts of code from different VBA's I'd written before that had the same function, in one I used Sheets, and in one Worksheets so this is a collection of both...
Check out photos of my trips here