Worksheet Selection Change

[DEFJ]

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

 

[Chip Pearson]

It would be most helpful if you posted the code that is causing the problem.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

if isempty(Target) then exit sub

at the top is a possibility.

or

if not isempty(target) then
' other checks

End if

 

[defj]

thanks again- works great (saved me from an ActiveCell
workaround)

 

[Dave Peterson]

I read this as trying to clear the contents of a range.

if you were doing
Target.delete

try:

Application.enableevents = false
target.clearcontents
application.enableevents = true

Disabling events means that changing the sheet in code doesn't cause the change
event to fire.