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

--
Message posted via http://www.officekb.com