I think we have to find out why these macros are not working on my code but they are working on the sample.

I don't think that there are leading spaces but how could I find out?

Let's take Jolivanes code for example. I am attaching a sample of initiating the debug.
Using the Debug, expression c becomes rangerange and expression i goes up to 35 and then goes to the next i.

Now what is happening is very strange. Columns E & F are filling up with the same numbers as in column D. [Column E without () such as 999-999-9999 and column F with () such as (999)999-9999] My column D contains 22 cells of numbers. Cells 23 to 33 fill up with (). I did not go through the whole debug but if I would run the macro without the debug, nothing would be changed.

Attached Images

delete duplicate macro.jpg (86.5 KB, 16 views)