+ Reply to Thread
Results 1 to 2 of 2

Memory Problems?

  1. #1
    Registered User
    Join Date
    WI, USA
    MS-Off Ver
    Office XP/2003

    Memory Problems?

    Hi all,

    I have a fairly simple spreadsheet (about 830 rows, no formulas, simple formatting). To edit the data here, a user form is shown, which calls a large amount of code (several hundred lines of code across more than a dozen routines). When I open the workbook and run the routine for the first time, it works fairly quickly. However, every time I run it after that, it slows down considerably.

    I've discovered the reason this is happening has to do with the delete/insert commands I have executing on the sheet. For example, if I manually delete or insert a row on the sheet (after the code is called a few times), it literally takes several seconds to complete. I would expect this on a very large sheet, but 830 rows isn't that many, and the increasing slowness (until the workbook is closed/reopened) makes me think it's a memory issue.

    I added the "End" statement to the very end of my last routine, thinking that'll clear any variables, and it does increase slightly, but it's still ugly... Any thoughts?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    Essex, UK
    MS-Off Ver
    Without seeing any of your code or the workbook it's hard to do anything other than agree that yes, it should not slow down if coded correctly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1