View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Worksheet Change Event Refuses to Action

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

On Jun 19, 10:22*am, Darren wrote:
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?