Okay thanks for pointing me in the right direction.
For the record, no I couldn't work this out for myself as I don't have much experience with writing macros or with this site. Please don't go assuming that everyone knows what you know.

Anyway thanks again, I've got it working now