What does this request have to do with Word?

Maybe post a sample Excel workbook with your request to the Excel Programming forum. Include how you envisage the macro to be used - it is not apparent how the macro should interact with the user.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia