worksheetFunction isblank

[tazgore]

I am trying to use this line of code in my user form:

answer = Application.WorksheetFunction.isblank("b2")

I have noticed that the function "isblank" is not given as an opito
using the auto complete. However in the spreadsheet itself "isblank" i
a valid function. Please help me call this function correctly, or tel
me how to to return a "true/false" based on wether the cell is empty o
not.

Thank

 

[Michael Hopwood]

answer = iif(Worksheet("MySheet").Range("B2").Value = "",True,False)