Macropod, sorry I just saw this response. I tried something different today. I copied my source data from a table in Word doc to an Excel spreadsheet and macro worked perfectly!