Spreadsheet causing memory leak

[WilliamWinn]

I have a spreadsheet on a form which is updated constantly.
The problem is that it is causing a memory leak.
Does anyone have examples of how to update the values in the spreadsheet without causing memory leaks?

thanks

 

[Sheco]

Please give additional details regarding the following element:
... spreadsheet on a form ...

 

[WilliamWinn]

I have a form with a spreadsheet object on it.
The data is updated from data from a communications control.

When the comm control receives a certain message it is added to the spreadsheet by looping through all of the cells and added using code that looks like this:

.ActiveCell.Offset(1, 0).Select
.ActiveCell.Value = "some value"
.ActiveCell.Offset(1, 0).Select
.ActiveCell.Value = "some value"

I can open the task manager and watch the memory and handles grow & grow. If I comment out the code that updates the spreadsheet, the memory is good.