Hello! I have in a xls, ColA: statements, Col B:D: int values that I want to use them in RGB formula for a formatting in PPT . I am not an expert I do not see a better/elegant solution and a “select case” it would be too long.. pCuloareRGB = CVar("RGB(Red:=" & valR & ", Green:=" & valG & ", Blue:=" & valB & ")") the result: “RGB(Red:=255, Green:=0, Blue:=0)” the error is: “Error 13” I do not know why it is still in string format (“ ”), because I used CVar conversion. Thank you in advance for your help and my apologize for my English!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Trouble to format txt in ppt, extracting the rgb codes from xls cells values ..

Thread starter natgeo
Start date Jun 20, 2011

natgeo

New Member

Jun 20, 2011

Hello!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
I have in a xls, ColA: statements, Col B:D: int values that I want to use them in RGB formula for a formatting in PPT .
I am not an expert I do not see a better/elegant solution and a “select case” it would be too long..
<o

></o

>
pCuloareRGB = CVar("RGB(Red:=" & valR & ", Green:=" & valG & ", Blue:=" & valB & ")")
the result: “RGB(Red:=255, Green:=0, Blue:=0)”
<o

></o

>
the error is: “Error 13” I do not know why it is still in string format (“ ”), because I used CVar conversion.
<o

></o

>
Thank you in advance for your help and my apologize for my English!