help with this function
 

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

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