Simon - Code for the timer

Hi Louisa,

Thank you for your request.

If you open the SalesPerson Report in from the VB editor screen and go to the Declarations area and:

1. Create a new public variable Public MyTimer as Double

2. Add MyTimer = Timer before the first procedure in the calling procedure.

3. Then add msgbox Timer - MyTimer after the IF statement

I hope this makes sense.

Let me know how long it took to run via the form.

Regards

Simon

Hi Louisa,

Further to the email I sent you.

Can you please put the MyTimer = Timer above the call deletespsheet in the CreateSPSheet procedure.

Add the msgbox Timer - MyTimer before end sub in the pivot table code.

Regards

Simon