View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tazgore tazgore is offline
external usenet poster
 
Posts: 1
Default worksheetFunction isblank


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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com