PDA

View Full Version : "Out of memory"



newuser23232
09-19-2007, 01:04 PM
I'm just starting to learn excel and I created a program to format a sheet and then load a userform. Everything works fine until I:

Userform.Show

Then I get an error that I'm out of memory. The program is pretty simple and I have 2 gigs of ram so I doubt I'm actually out of memory. Any thoughts on what could be wrong?

mdmackillop
09-19-2007, 01:38 PM
Welcome to VBAX
Can you post your workbook? Use Manage Attachments in the Go Advanced section.
Regards
MD

newuser23232
09-19-2007, 01:58 PM
It actually won't let me save the document now. It has information about an investment portfolio so I can't post it without changing the investments. When I go to save it, it says "file not saved"... I'm guessing this is related to my other problem...

newuser23232
09-19-2007, 02:13 PM
Actually I was able to save it with just one security listed where all of the actualy securities are. Thanks a lot for looking at it.

newuser23232
09-19-2007, 02:33 PM
one other thing. The code under sub main () should be: userform1.show (I think in the one I uploaded it's userform.show).

mdmackillop
09-20-2007, 12:09 AM
I'm not getting any problems and I have less than half your RAM.
Just for neatness, I would add in screen updating to Main.
Sub Main()
Application.ScreenUpdating = False
Call FormatPortfolio
Call CheckIfSummarySheetExists
Call Summary
Application.ScreenUpdating = True
UserForm1.Show
End Sub

newuser23232
09-20-2007, 05:19 AM
Thanks for trying. I didn't have any trouble at home when I tried it either. Could a lot of add-ins at work be causing it? I have a bunch of financial software menus (bloomberg, capital iq, crystall ball, etc)? Could it be a virus or something else? Thanks again for your help.

mdmackillop
09-20-2007, 08:27 AM
Trial and error I'm afraid.