Posted to microsoft.public.excel.programming

Ozgur Pars[_2_] Ozgur Pars[_2_] is offline

external usenet poster

Posts: 70

How much memory does VBA code occupy?

Hi,
I know its probably a dumb question but I have a file in which I copy data
from another workbook through named ranges. Its a fairly big amount of data
so when copied the file is aroun 2.5 MB but when I delete all the data the
workbook is still 1.1 MB... does simple code take that much of space.

Thanks,
Oz

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a chart series (row-based) occupy more than one row	Rick	Charts and Charting in Excel	2	October 3rd 09 05:24 PM
Sometimes entering simple function causes it to occupy two cells, why?	[email protected]	Excel Worksheet Functions	2	November 29th 06 06:37 PM
Request code help, sorting array in memory	KR	Excel Programming	2	November 8th 05 07:08 PM
VB Code Remains In Memory	Paul Moles	Excel Programming	9	December 13th 04 02:13 PM
VBA Code runs out of memory - too much copy/paste?	Rachel Curran	Excel Programming	0	May 27th 04 10:08 AM

All times are GMT +1. The time now is 12:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us