Worksheet Change Event Refuses to Action

[Darren]

Hello,

I have created the following code in the Worksheet / Change section of
Objects (as opposed to in Modules):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$j$12" Then
Call microbusiness
End If
End Sub

However, when I make a change in the cell j12, it does not call my
macro as it should. Is there something I am doing wrong?

 

[paul.robinson]

Hi
Try a capital J. I never realised lower case was a problem either!
regards
Paul

 

[Susan]

Targets are case-sensitive.

susan

Hi
Try a capital J. I never realised lower case was a problem either!
regards
Paul






- Show quoted text -

 

[Darren]

Targets are case-sensitive.

susan





- Show quoted text -

Thank you both. I could have looked at this problem all day long and
not thought of that.