To shorten the VBA code

[gan_xl]

Hi Team,

I have the following vba code and assigned it to a button. It is working fine but it takes 2 minutes to execute. Please let me know how to shorten this code to execute faster.

Please Login or Register  to view this content.

[Bernie Deitrick]

Seems like every entry must be forcing a re-calc.

Start with:

Please Login or Register  to view this content.

and finish with

Please Login or Register  to view this content.

[gan_xl]

You are really great. Thank you so much. It executes within 10 seconds now.