+ Reply to Thread
Results 1 to 3 of 3

Code to Hide Rows adds 5MB to File Size

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Worcester, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Code to Hide Rows adds 5MB to File Size

    Hi All.

    I have this small piece of code which hides rows in a worksheet dependant upon the data in a cell. It works fine, however it adds 5MB onto the size of the file. If anyone has an alternative method of achieving the same please let me know.

    Thanks!

    Simon

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: Code to Hide Rows adds 5MB to File Size

    The macro itself is not causing the blot - there is something else going on with your sheet.

    Does the bloat happen if you perform the same steps as the macro manually?

    Here is a condensed version of your macro - it avoids the selection steps your original macro contained.

    Please Login or Register  to view this content.
    Last edited by mdbct; 03-18-2009 at 10:42 AM.

  3. #3
    Registered User
    Join Date
    01-14-2009
    Location
    Worcester, England
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Code to Hide Rows adds 5MB to File Size

    Thanks.

    I've inserted your code and it now executes faster, so thanks for that. I'll go back to an old version pre this code and try manually hiding the rows and see what happens, and then apply your code to it to see the effect on the file size.

    Thanks for your time.

    Simon

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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