You've asked this question in a Word forum but looking at the wording of your question, perhaps you are using Excel. Can you confirm that your data and macro is in Word?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia