Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA function returning the value EMPTY
Is it possible to make a userdefined worksheet function return the value
Empty ? What I need is a VBA function like : Function Func_Empty(ByVal X As Variant) As Variant If IsError(X) Then Func_Empty = SomeThing Else Func_Empty = X EndIf End Function SomeThing should not be 0 (zero), "" (empty string), or #N/A. I should function as if I had manually deleted the value in the cell in question. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA function returning the value EMPTY
Hi Helge,
Is it possible to make a userdefined worksheet function return the value Empty ? No. A used defined function allways returns something. You could set the result to an empty string: Func_Empty="" Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop index match returning data where lookup cell empty | Excel Worksheet Functions | |||
Returning Data to an empty Cell | Excel Worksheet Functions | |||
Function argument not returning a value | Excel Worksheet Functions | |||
Returning an empty cell when no data present | Excel Discussion (Misc queries) | |||
Returning value from function | Excel Programming |