View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helge V. Larsen[_2_] Helge V. Larsen[_2_] is offline
external usenet poster
 
Posts: 2
Default 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.