Cheers for the quick responses!

Thanks Chris I tried using your code but it didn't work :( never mind
I'll just have to keep on the lookout for a better way.

I tried what you said Tom and I think I am getting a slight decrease in
the time taken but its still taking 1min+ unfortunately...

Never mind, it still beats doing it manually! :D

Thanks again,
Sau


---
Message posted from http://www.ExcelForum.com/