View Single Post
 
Old 07-04-2021, 04:33 AM
Shelley Lou Shelley Lou is offline Windows 10 Office 2016
Expert
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA to only remove word at beginning and not additional instances within the same paragraph

Hi Andrew, wow many thanks for this code, I have tested it on several documents and I've only come across a couple of issues namely if a space after the word 'means' is bold the macro doesn't recognise it and puts all the text in column 1 and secondly, if the bold definition wording is in capitals e.g VAT it inserts the unique code next to VAT. I will have a go at sorting these myself, see what I can come up with. Again though thank you so much for helping me I really appreciate it.
Reply With Quote