Still doesn't work. It now puts #CLIN# in the CLIN column and doesn't pass the variables to the
HREF tag.


------------
Mark at 4/9/01 3:18:09 PM

Chad,

Use:
CLIN||
instead of
CLIN,,

Mark.


------------
Chad at 4/9/01 3:13:54 PM

I added a Hyperlink to a magic cell (mc2) and the column is unaffected by the code. The Hyperlink works
fine if mc1 is remarked out, but then the currency format quits working. Any suggestions would be great.
Thanks,
Chad

fm = "format=[currency]"
mc1 = "(;|[]@)"
mc2 = &#34;CLIN,,<A HREF=Chart.asp?PC=#PercentComplete#&Schedule=#Sche dule# TARGET=NEW>#CLIN#</A>;&#34;
mc3 = &#34;Funded | align=right| $format=[###,###,###.00];&#34;
mc4 = &#34;Committed | align=right| $format=[###,###,###.00];&#34;
mc = mc1 & mc2 & mc3 & mc4
MyDb.dbMagicCell = mc