View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren[_2_] Darren[_2_] is offline
external usenet poster
 
Posts: 9
Default Worksheet Change Event Refuses to Action

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?