Hi, I need to use 1MB data within VBA at the same time. However, VBA told me that exceed the VBA limit. Does anyone know how to open up VBA memory allocation? Thanks.

Tracy

Doesn't sound right to me, 1mb is peanuts, can you describe what else is going on in you pc's world. I sometimes get messages informing of problems with the virtual memory size, usually sorted out by closing unwanted applications especially Outlook and other memory resident apps.

Hope I can help.

Matt