excel freezing

[john.9.williams]

Hi I am writing a program and i am having a problem, the program has
multiple forms and multiple sheets, as i using the program or editing
the data on the sheets my excel is freezing up, i use the
ctrl-alt-delete to shut down and the excel.exe process is taking up
100%, i have tried exporting and importing onto a different pc but it
stills happens, anyone got any ideas

thanks

johny

 

[Oliver Ferns via OfficeKB.com]

Hi john,
not much to go on there but it sounds to me as if you are not doing a
couple of things that you need to do to free up memory. Namely:

1. Unload your forms when they are not in use and
2. Set all object variables used in Subs and Functions to Nothing at the
end of your routines

Sub Demo()
ie Set objChart = Thisworkbook.sheets(1).charts(1).chart
.......(your code)

Set objChart = Nothing
End Sub

Hth,
Oli