View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MaR MaR is offline
external usenet poster
 
Posts: 17
Default Basic programming help

Code:
Function getsask(ByVal SaskNr As Integer, ByVal Target As Range)
Dim a As Integer
a = Target.Offset(1, 0).Value

getsask = a
End Function

When I do =getsask(1, A1:A2) i get #VALUE!

Any ideas how to correctly get Integer from cell?