Worksheet Selection Change
thanks again- works great (saved me from an ActiveCell
workaround)
-----Original Message-----
if isempty(Target) then exit sub
at the top is a possibility.
or
if not isempty(target) then
' other checks
End if
--
Regards,
Tom Ogilvy
DEFJ wrote in
message
...
I have an if/then statement on the worksheet "Change"
method that checks the value of 'target' and acts
accordingly. It works except when you use 'Delete' to
empty out the cell. I get a data mismatch error. I'm
guessing it's because target can't equal 'null'. Is
there
any way around this?
Thanks in advance
.
|