Worksheet change failing to initiate
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.
Hi,
Target.Address will return $G$12 which is not the same as $g$12, since the = operator is case sensitive.
Don
Please remember to mark your thread 'Solved' when appropriate.
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
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks