Thanks Killian, I will try that.

Although this is probably the wrong forum for "advertising", can you reccommend a good book for a beginner-improver for VBA? I already have a basic one called VBA for Excel: it has been a good introduction to VBA structure, i.e. subs, functions etc, and logic routines. I am now looking for a bookwhich can help introduce more sophisticated properties/functions etc, particularly to help with MS Office applications.

All your help has been clear and easy to understand, and most importantly, effective, so I would like to thank you for all your help.