Excel Worksheet Increases Size when running the macro

[bhuvana]

Hello,

I m having an Excel Worksheet that has 5 macros. When i wrote the macro and saved it, the size of the Worksheet was just 16.91 Kb but once i run the macro it increases its size to 14.35 MB. Can you please tell me what is reason behind the sudden increase in the size of the Excel Worksheet, and how to reduce the space.

I do have the Vlookup and formulae written in the same worksheet. And also I'm using a Xml post that posts the data to the net.

Waiting for your reply
Thank you
Bhuvana

 

[schielrn]

What is the code doing? Can you post the code? Also what is the vlookup formula you are using and is the macro insertign that formula into the workbook?

I assume you have some inefficiencies in the code that maybe are populating too many cells or causing Excel to think these cells are being used. Also the vlookup can make the size go up when it holds that data in memory when it is closed.

 

[bhuvana]

Thank you schielrn,

As you told its all because of the inefficiency in the code. I checked my code and found that have taken all the cells and formatted with border, hence it increased its size after running the macro. So now i changed the code and have formatted only the required cells which is just 2 kb increase (which is very fine).

Regards
Bhuvana