View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
compound
 
Posts: n/a
Default Is it possible with functions?


Great Day!
I have a user defined function in a cell A1 and I would like to return
value to the cell B2

For example if I have function:

Public Function MyTest(ByVal sInput As String)
Application.Range("MyRange") = sInput
End Function

If I put this function in to cell A1 and name cell B2 “MyRange” then I
get an application error.

Thank you.
Compound.


--
compound
------------------------------------------------------------------------
compound's Profile: http://www.excelforum.com/member.php...o&userid=11556
View this thread: http://www.excelforum.com/showthread...hreadid=555131