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