Worksheet Change Event Refuses to Action

D

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?
 
P

paul.robinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass value variable to worksheet event 3
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Simple Copy Paste within Worksheet Change Event 2
Change event to add button 2
Run procedure in stored in module on worksheet change event 5
Worksheet Change Event macro fails intermittently 6
Include Dropdowns and Checkboxes in Worksheet Change event 1
Help with combining 2 seperate Worksheet Change Event scripts 2

Top