Allow Copy and Paste function through VBA Auto Calculation

Dear All

I wonder if someone can point me in the right direction please.

I am trying to allow the copy and paste function to function more than once on a sheet in excel but i have the code below in the worksheet to auto calculate the sheet when certain cells are populated. With the code not there it works fine, i am able to copy once and paste many many times.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you only have a few posts, but you have been here long enough to know better. --6StringJazzer


Thanks in advance

Juicy

Calculate wipes out the clipboard. Why do you even need this macro? Formulas will be recalculated automatically, unless you have Manual Calculation set (normally not a good idea).