Sorry guys, one more question. In mana's code he sets his range to the the selection.

For my purposes, I need to select a column of data and run the code. I don't want to process the first heading row. How do I adapt:

Set r = Selection

such that the range excludes the first row.

I tried this (among other things) but get and error:

Set r = Selection.Offset(1, 0)

Thanks.