View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Lars-Inge Tønnessen \(VJ# MVP\) Lars-Inge Tønnessen \(VJ# MVP\) is offline
external usenet poster
 
Posts: 5
Default VBA How do I set a value in a cell?

This gave me "#VALUE!":

Formula in cell M16 "=go()"

Public Function go() As String
Worksheets("Sheet1").Range("M5").Value = "hello"
End Function


Regards,
Lars-Inge