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
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