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
|