Quote:
Originally Posted by jc491
I was just wondering, does the font need a name? I could not find a column for the font name.
|
If you want to use that as a parameter, yes.
Quote:
Originally Posted by jc491
For the RGB I would need to add the code below
|
Actually, you might need both a Find colour and a Replace colour. And, unless you're actually using RGB values, I'd not be inclined to use RGB as part of the variable's name - perhaps xlFClr & xlRClr would be more appropriate.
You also would NOT want:
Code:
If Split(xlRRGB, "|")(i) <> "" Then .Size = Split(xlRRGB, "|")(i)