Re: Chip code problem - conditional formatting colors GetStrippedValue

From: Dave R. (daverx_at_hotmail.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 14:42:18 -0700

Barney- try posting over at
www.excelforum.com or at the microsoft support portal.

the posts will appear much faster on the newsgroup.

"Barney Fife" <BarnEFife3@hotmail.com> wrote in message
news:79d47a5e.0406161302.149d155@posting.google.com...
> Very sorry if this is duped - Google Usenet posting is not quite prime
> time, and gave several "page not founds" on submission; then a good
> "submitted" page, but that was many hours ago and AFAIK never made it.
>
> re: http://www.cpearson.com/excel/CFColors.htm
>
> I'm having problems with the function GetStrippedValue at the bottom
> of that page. With highest respect for Chip there seems to be a bogus
> line
> Temp = Mid(CF, 3, Len(CF) - 3).
>
> Perhaps it should be
> Temp = Mid(Temp,2)
> or
>
Temp=Mid(CF,1+InStr(1,CF,"=",vbTextCompare)3,Len(CF)-InStr(1,CF,"=",vbTextCo
mpare))
>
> but my cylinders aren't all quite firing as to why GetStrippedValue
> thinks there might be equal signs where it is looking for them. I'll
> defer to the experts on that.
>
> P.S. Several email reports to Chip on this apparently bit-bucketed