How can we reduce the excel file size

[lovejanu4u]

I want to reduce the excel file size, even i am using VBA code still it increased the file size to 3 mb.

 

[mse330]

Save the file in .xlsb format, ensure last row/column is within your actual needed used range

 

[lovejanu4u]

Save the file in .xlsb format, ensure last row/column is within your actual needed used range

Thank You mse330 its working.

 

[mse330]

Glad I could help & thanks for the feedback