Macro with calendar runs slow

Hello,

I am working on a macro which hides rows depending on the date that you select from a calendar I have created. The problem is that this macro runs quite slow and would appreciate if someone could help me on this to make it run a bit better.

I have attached the excel sheet so that you can better see it.

Any help would be much appreciated.

Thanks!!

Hello,

Yes is quite big. I tried to delete some things but its still maybo too heavy.

I herewith attach the the code which makes run slow the macro just in case someone can detect something that makes it run slowly.

Please Login or Register  to view this content.

Im sure that what is giving the problem here is that my range goes up to row 50.000 !!
But the reason why Im selecting so huge range is because there is a lot of data that I will be introducing and would like to have a big range to work with. Maybe someone knows how to optimize better this code.

Thank you very much.

Regards

Hello,

Found the error, nothing to be with the code I uploaded. There where too many formulas on it that was slowing it down.

regards