Hello Graham,

and happy new year.

How did you do this?

I love it! - it's exquisitely awesome!

You are too good to me.

I tried the wild card regex search to find the DNS -but how was I supposed to find the ensuing range? Some of them are very long ranges.

As you can see I butchered the predecessor code, and did it lash out at me like a snake.

I have long documents that were giving me the shivers.

Also I just can't deal with copy and pasting .

After 10 paragraphs copy and pasting - long ranges - That's a lot of dragging and selecting to do and thanks to my introduction to the VBA I knew there must be a better way.



This is dazzling magnificent.

I will use it every day.


I am happy as Larry as they say - my Friday is perfect.

Thank you soooooo much


I hope you will have a great weekend

Saphire

xo



This is Solved