"Out of memory"

[newuser23232]

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]

Welcome to VBAX
Can you post your workbook? Use Manage Attachments in the Go Advanced section.
Regards
MD

[newuser23232]

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]

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]

one other thing. The code under sub main () should be: userform1.show (I think in the one I uploaded it's userform.show).

[mdmackillop]

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]

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]

Trial and error I'm afraid.