something more about it

  • Thread starter Thread starter =?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=
  • Start date Start date
?

=?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=

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
 
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
 
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
 
Back
Top