Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    32MB????? (2000 sr 1)

    My workbook contain 10 sheet and for every sheets i have cleared all column and cells, i save this and the dimension is 32Mb??????????????

    Possible?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 32MB????? (2000 sr 1)

    The following may help, but I can't guarantee it.

    See the thread starting at <post#=133048>post 133048</post#> for a way to clean a workbook. And VBA"]http://www.appspro.com/Utilities/codecleaner.htm">VBA Code Cleaner[/url] for a free add-in that cleans the VBA code, if you have any.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 32MB????? (2000 sr 1)

    Tks HansV, in this tiem the dimension is 2,8Mb, but the macro has changed manuy format....

    For the second optio ClearCode i dont have undestand completly...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 32MB????? (2000 sr 1)

    Formatting takes up space, even in unused cells. The code from the thread I referred to clears all unused rows and columns. As you found, this has reduced the size of your workbook enormously. But as a consequence, formatting of those unused rows and columns is lost.

    The Code Cleaner from Rob Bovey is an add-in. If you install it, it will add a new item to your Tools (Strumenti) menu: Clean Project. Select this, then select the workbook whose code you want to clean up.

Posting Permissions

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