Thread: VBA Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
magix magix is offline
external usenet poster
 
Posts: 14
Default VBA Range

Hi,

If I have VBA Function, what is the correct statement to insert a value into
a particular cell, let say cell A1 ?

Function ABC ((S1 As String) As String


' how can I set the value at particular cell ?
Range("A1").value = S1
...
...
End Function

is this Range("A1").value = S1 correct ? or Application.Range("A1").value =
S1 ? or... ?