Hi Paul

thank you so much for all the help!

This is beyond outstanding!

I am really speechless.

I have been in a deep despair at the documents I have to work with, formatting like its from the era of cave man, that is some one went overboard with their idea of styling text - like there is no tomorrow.

I have an editing nightmare on my hands.

Unfortunately I can't remove all the formatting - as its styled in blocks of content and it has to be dealt with individually - this is where the problem arises. Replace this font with that font and style etc etc.....


Now multiply that by a nice folder full of hundreds of docs - you can imagine the sheer delight I feel , when having to physically copy paste and replace text fonts and styles.
It also really exacerbates my RSI problem - so this is a life saver bar none!

If I could do a cartwheel I would.

I am so grateful you suggested and coded the epic spreadsheet VBA module.

Thank you also to Graham for his table - which I will still use, that is excellent and I will use for block tasks.

I hope Microsoft continue to recognize how much individuals like yourself contribute to making their products better.

I despair at the help materials on VBA on their site - How are people supposed to learn when they have nothing of value or substance - one sentence telling me what the word means is a circular reasoning fail.

Many of the pages have similar to below with no example

expression .End
expression A variable that represents a Range object.

That does not really tell me much now does it.


Paul you are the man. There is no way I could have done this at all!

Thank you you are a VBA STAR*****

Thank you so much for making my life and thousands of others who can use this better.

J

PS - I won’t forget all the help


Also - I will be back in the future - to ask you how to add on to it - not now though this is more than enough

Have a great week and week end!!