Hi Greg, I would very much welcome any thoughts or observations you have on how I can improve/streamline the code further, as any help would be very much appreciated.
The next part of the code I am trying to update is how manual cross references are highlighted. For example, this line of code only highlights the cross reference immediately after the string words:
Code:
.text = Split(StrFndA, ",")(i) & "[s ^s]@[0-9.]{1,}"
but doesn't capture if there are further cross references separated by the words 'and', 'or', 'and/or' or a comma, e.g. clause 1 and 1.1 or clause 1, 2 or 2.1.
I've been testing in a separate macro but haven't got anything working as of yet with my IF Statement, so its still a work in progress at the moment.