Hi Carl
I changed the ClearReport macro from just deleting the contents of the service report sheet to include the hiding of the rows.
I changed the worksheet change macro by removing & changing some of the code.
I hope it's what you're after
Cheers
Phil
|