Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheetFunction isblank
answer = iif(Worksheet("MySheet").Range("B2").Value = "",True,False)
-- Michael Hopwood (Phobos) "tazgore" wrote in message ... 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 opiton using the auto complete. However in the spreadsheet itself "isblank" is a valid function. Please help me call this function correctly, or tell me how to to return a "true/false" based on wether the cell is empty or not. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WorksheetFunction help | Excel Discussion (Misc queries) | |||
Can't use WorksheetFunction | Excel Discussion (Misc queries) | |||
WorksheetFunction with VBA | Excel Discussion (Misc queries) | |||
worksheetfunction | Excel Programming | |||
Worksheetfunction MATCH | Excel Programming |