Excel VBA - Out of Memory Compile Error

[BGumm]

I get this error message:

Compile error:

Out of memory

The code is incredibly simple, and I'm running with more than enough memory to support it (my indicators say I'm using less than 47% when this is being run):

Private Sub cmdConfirmExistingData_Click()
    Sheet9.Visible = xlSheetHidden
    Sheet10.Visible = xlSheetHidden
    Sheet11.Visible = xlSheetHidden
    Sheet12.Visible = xlSheetHidden
    frmNewDataConf.Hide
    frmDataEntry.Show
End Sub

Any ideas how to fix this? Thanks!

 

[BGumm]

Nevermind. My frmDataEntry was too large, which is where the error was being encountered. I split it into two, so now everything is working fine.

Thanks!

 

[SkipVought]

Hi,

Glad you got it sorted out.

In the future, please post VBA questions in Forum707.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]