What is the correct way to call a macro when an empty cell is no longer empty?
In cells C6:C10 and C13:C40 are empty right now, what I need to do is call my macro when one of those cells is no longer empty. I've tried using:
If Target.Address <> "C6:C10" Then Exit Sub
If Target.Address <> "C13:C40" Then Exit Sub
If Target.Address <> "" Then Call MacroName
And I've tried using:
If Cells("6,C") <> "" Then Call MacroName
So I don't use up space I did the above for each cell that is currently empty.
I used this code to call a macro before:
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$G$11" Then Exit Sub
If UCase (Target.Value) "Word" Then Call MacroName
Which worked well as long as I entered the specified word in the specified cell. But I don't want the user to have to enter the data and then enter the word to get the macro to activate. I prefer to have the macro to be called as soonafter the new data is entered.
In cells C6:C10 and C13:C40 are empty right now, what I need to do is call my macro when one of those cells is no longer empty. I've tried using:
If Target.Address <> "C6:C10" Then Exit Sub
If Target.Address <> "C13:C40" Then Exit Sub
If Target.Address <> "" Then Call MacroName
And I've tried using:
If Cells("6,C") <> "" Then Call MacroName
So I don't use up space I did the above for each cell that is currently empty.
I used this code to call a macro before:
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$G$11" Then Exit Sub
If UCase (Target.Value) "Word" Then Call MacroName
Which worked well as long as I entered the specified word in the specified cell. But I don't want the user to have to enter the data and then enter the word to get the macro to activate. I prefer to have the macro to be called as soonafter the new data is entered.