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