Hi Guessed

Thanks for posting again - really appreciate your input.

First run your code through seemed a little slower at 48 seconds for the 100 test records, then I ran it again and it came up as 28 seconds!

I guess the process is just massively skewed by environmental factors (ie what else the PC is doing) and I'm going to have to do several more tests and use larger numbers of records and then see what the results are. I've not seen this degree of variance in vba code before, but I guess I'm not usually so concerned with speed.

2 oddities with your code which I can't quite explain:

1. the status bar update text doesn't buff out 50 spaces from the edge, it just sits the code to the left hand side of the screen.

2. The shrink never seems to tackle the first text box it finds - it always skips that but does the rest - weird!

Anyway, I'll do some more tests tomorrow and post my results.