View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default help with this function

If it is blank you want when blank, why not just use

Function info(x)
info = Worksheets("General INFO").Range(x).Value
End If

or better still, why not use

='General INFO'!A99

in the cell, or whatever c ell you pass in x.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"steve" wrote in message
...
Function info(x)

If Worksheets("General INFO").Range(x).Value = 0 Then
info = ""
Else: info = Worksheets("General INFO").Range(x).Value
End If

End Function

i want to check the specified cell, if it is blank, give me blank,

otherwise
give me the value