Perhaps if I had looked at your code before posting I would have seen
it does everything I needed.

Thanks again Bob it was much appreciated.

All I did was replace the ".Row" with ".Value" and all worked to
perfection.

Robbie