VBA/Excel - Out of Memory

Question

Hi all,

I'm coding a Macro in VBA for Excel 2007 (file type .xlsm)

My Macro runs very well for the first time. But, at the second run, when i give the variable (an array of thousand items) a new value, the VBA says "Out of Memory".

I tried with different commands: Set Obj = nothing , Erase variable, variable = empty but it didn't work. The only solution is to restart my Excel, then it's done !

Does anyone have a problem like me ? Do you have some solutions plz ? Thanx