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

 

[snowblizz]

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

Ho-hum. Odd that. I was wondering if there was a reasonable technical explanation for what went wrong. As you say "merged cellism" tends be to blame but I wondered if there was some logic to why it didn't work.

 

[BigDelGooner]

I am sure there is but unfortunately my knowledge doesn't go that far.

Sorry I can't be more help.

 

[BobbyCharltons]

A possible work-around (if you don't want to or can't unmerge cells), seems to be available using Target.Cells(1).Address in place of Target.Address

 

[BigDelGooner]

A response over 3 years later...that is dedication sir!

Thank you though, always useful.

By far the best Excel community.

 

[GTO]

@BobbyCharltons:

Not testing tonight, but I ('blond' brain and all) think I will remember that! Nicely done!

Mark

 

[volz]

@BobbyCharltons: wow, thank you! I've been struggling with this same problem!