Worksheet change failing to initiate

[Si-Phy]

Hi

Have code where I want an action to happen based on a cell value changing.

The code below works on other cells and sucessfully completes the action, however for some reason this specific cell range fails?

I cant give an example as it only happens on the actual worksheet( so cant share)

What elements should i look out for that make this fail ??

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Target.Address will return $G$12 which is not the same as $g$12, since the = operator is case sensitive.

[MarvinP]

Hi Si,

Your code is trying to fire only when the Target.Address some address. Try this instead of
If Target.Address = "$g$12" Then
try
If Target.Address = "$G$12" Then