Need help with empty cell in Macro

[Don]

set var2 in macro that returns " " when cell is empty.
Need statement that says If var1 = x or var1 = y and
var2 not " " Then

Can anyone help?

 

[Guest]

hi,
if var1 = "x" or var1 = "y" and var2 not isempty then

 

[Tom Ogilvy]

if (Var1 = x or var2 = y ) and not (var2 = " ") then

 

[Kris]

Not quite.

1) IsEmpty is a function. So the correct use of a
function would be something more like:

If Not IsEmpty(var2)

2) IsEmpty returns True if the variable has not been
initialized, not if the variable is blank. And there is
a difference between the two. The following example
illustrates this:

Dim var1 As String
Dim var2

If IsEmpty(var1) Then
MsgBox "Var1 is Empty"
End If

If IsEmpty(var2) Then
MsgBox "Var2 is Empty"
End If


Sincerely,

Kris

 

[Tom Ogilvy]

Typo: (should be)

if (Var1 = x or var1 = y ) and not (var2 = " ") then