Code to Hide Rows adds 5MB to File Size

Hi All.

I have this small piece of code which hides rows in a worksheet dependant upon the data in a cell. It works fine, however it adds 5MB onto the size of the file. If anyone has an alternative method of achieving the same please let me know.

Thanks!

Simon

Please Login or Register  to view this content.

Thanks.

I've inserted your code and it now executes faster, so thanks for that. I'll go back to an old version pre this code and try manually hiding the rows and see what happens, and then apply your code to it to see the effect on the file size.

Thanks for your time.

Simon