"IsEmpty" Function

[Mackeral]

I have found 2 different versions of documentation for the VBA function "IsEmpty":

One on TechNet says the function is used to test "if the value is a blank cell or uninitialized variable, the function will return TRUE. Otherwise, the function will return FALSE".

The other on Microsoft says the function returns "TRUE if the variable has as been initialized, otherwise it returns FALSE.

My own solution to this delima is the following Function:

Function Is_Empty(Argument
       Is_Empty = IsEmpty(Argument

[COLOR=#333333][FONT='inherit']) or Argument = ""
End Sub ' Is_Empty()[/FONT][/COLOR]

Mac

 

[Norie]

What dilemma?

 

[jproffer]

The sources posted say 2 different things, according to what was quoted.

I'm pretty sure IsEmpty = True......means that whatever cell or variable you're testing Is....well, ya know...Empty

I'm pretty sure whichever source said "will return True is the variable is initialized" mis-typed.

 

[Rick Rothstein]

The other on Microsoft says the function returns "TRUE if the variable has been initialized, otherwise it returns FALSE.

Can you post a link to where you read that?

 

[Fluff]

Not sure if it's the the OP was talking about
https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/isempty-function

 

[Rick Rothstein]

Not sure if it's the the OP was talking about
https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/isempty-function

I don't think so as that correctly states True for uninitialized variable whereas the OP said Microsoft said the opposite... "TRUE if the variable has been initialized,"

 

[Fluff]

Oops misread what it said.