youngmanca
Thu Aug 19 21:36:09 CDT 2004
thanks for your reply.
the problem is that a graph cannot be attached in my mail,
i mean the value is ok,but if i click the "=" in fomula area ( to show the
dialogbox of the function)
the error message (#name? errors) will appear, red and striking.
thank you
regard
"Jerry W. Lewis" <post_a_reply@no_e-mail.com> wrote in message
news:41233951.20703@no_e-mail.com...
> When I paste your code into a module and run it, it executes without
> error, and there is no error associated with the formula that was pasted
> into the ActiveCell. I do not understand your statement/question that
> begins "but the following message ...". Try writing it less
> cryptically if you are still having problems.
>
> Jerry
>
> EXCEL NEWS wrote:
>
> > thanks for your help.
> >
> > sorry to let me ask something more about it.
> >
> > Function getval(v, chara, chara1, chara2, chara3, chara4)
> > getval = v
> > End Function
> >
> > Sub funtest()
> > v = 123
> > c = "ok"
> > c1 = "ok"
> > c2 = "ok"
> > c3 = "ok"
> > c4 = "ok"
> > c5 = "ok"
> >
> >
> > ActiveCell.FormulaR1C1 = "=getval(" & v & "," & c & "," & c1 & "," & c2
&
> > "," & c3 & "," & c4 & ")"
> >
> > 'ActiveCell = "=getval(" + v + "," + c + ")"
> >
> > End Sub
> >
> > the value is ok.,but the following message (#name? errors) appears
> > ,why,(when click "=")
> >
> >
> > regards
> >
> >
>