Delete key not activating Worksheet_Change procedure

[BigDelGooner]

Hi all

The code below works fine when I change a value in cells B6,B7 or B8 but when I delete a value in these cells using the delete key the procedure is not activated. I presume its that the delete key command is effectively classed as a ClearContents and not an actual change, any ideas on a workaround for this though?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$6" Then
FrontPage_Summary
End If

If Target.Address = "$B$7" Then
FrontPage_Summary
End If

If Target.Address = "$B$8" Then
FrontPage_Summary
End If
End Sub

 

[BigDelGooner]

FrontPage_Summary is just a procedure I have in module1 that manipulates data in another sheet. Although even if I replace this with a simple msgbox it still doesnt work..

 

[snowblizz]

Funny, because this works for me:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$6" Then
MsgBox Target.Address ' FrontPage_Summary
End If

If Target.Address = "$B$7" Then
MsgBox Target.Address 'FrontPage_Summary
End If

If Target.Address = "$B$8" Then
MsgBox Target.Address 'FrontPage_Summary
End If
End Sub

 

[BigDelGooner]

Placed the breakpoint and it does activate the code but does not recognised the address...which has led me closer to the answer. B6 is actually merged with cell C6!!

 

[GTO]

Yet another testimonial to banning evil merged cells.... lol

 

[BigDelGooner]

**** those merged cells!! I really should have known better!!

Thank you, as always, for your support guys.

Have a good day.

 

[VoG]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B6:B8")) Is Nothing Then Exit Sub
FrontPage_Summary
End Sub

 

[BigDelGooner]

Thanks VoG but managed to change some formatting and removed the merged cells.

Have a good day.

 

[snowblizz]

Would it be correct that the rationale behind it not working is that in a merged cell the Target.Address would be "B6:C6"?

I had an involuntary run in with a merged cell once. Luckily you guys could figure out what had happened. They really are the spawn of the Nether regions.

 

[BigDelGooner]

No because I setup a variable to check the address of the the target cell and it still said $B$6...just going to put it down as a merged cellism

 

[GTO]

...