Syntax when referring to self

J

Jack Schitt

General syntax question:

This does not work:

With Cell_Object
If .Value = 0 And Not(IsEmpty(.) Then .EntireRow.Delete Shift:=xlUp
End With 'Cell_Object

I am looking for a general way to refer to the object that is the subject of
the "With ..." statement within that "With .." "loop".
In the above example it would be substituted for the "." contained within
the "IsEmpty() expression.
But that is just an example and I am looking for a general method.

I tried Not(IsEmpty(.me)) but whilst that compiled OK it failed on run time
(error 438, does not support property or method)

Thanks
 
A

AA2e72E

Try:

IsEmpty(.Value)

IsEmpty takes a literal value or a pointer i.e variable name or object like
ActiveCell.
 
A

Alan Beban

Jack said:
General syntax question:

This does not work:

With Cell_Object
If .Value = 0 And Not(IsEmpty(.) Then .EntireRow.Delete Shift:=xlUp
End With 'Cell_Object

I am looking for a general way to refer to the object that is the subject of
the "With ..." statement within that "With .." "loop".
In the above example it would be substituted for the "." contained within
the "IsEmpty() expression.
But that is just an example and I am looking for a general method.

I tried Not(IsEmpty(.me)) but whilst that compiled OK it failed on run time
(error 438, does not support property or method)

Thanks
Click to expand...

Why doesn't .Value = 0 already negate IsEmpty(Cell_Object)?

Alan Beban
 
D

Dave Peterson

VBA sees an empty cell as something that can be used as numeric 0.

kind of like =a1 returns a 0 if the A1 is empty.
 
Top