Hello Richard and thanks for your prompt replies.
To be honest I have about 6 weeks of VB experience now so I can't say I know anything about dynamic ranges, but I'll do some research.
I'd appreciate any links that you might be able to send me that can point me in the right direction.

Jaslake - thanks for your feedback also. I'll certainly keep your feedback in mind for future posts!!

Thanks again

Steve