Paul and Graham,

Gentlemen thank you for your generous input and help .

Graham the table did pick up the formatted version - So if i need to add on new font types, I need to add a new code block to the main code - I assume.

Paul thank you for coding the extra advanced spreadsheet version - I can see it is a lot of work thank you for taking the time out to do this.


Just a quick point

Am I setting up the workbook correctly

error popped up

.Format = CBool(Split(xlFFrmt, "|")(i))


I do believe this may be the answer to reducing all those individual macros, if I can lay it all out in one place as per the spread sheet or Graham's Table - save me from running macros individually like a conveyor belt

I'm also going to see if its possible to add a column for the font RGB color -

I have attached the workbook

Pardon my instruction reading skills again - I do tend to go at a snails pace

Thank you ever so much

Really indebted to you

J

Attached Files

BulkFindReplace.xlsx (8.9 KB, 11 views)