G
Guest
Hello, im hoping someone can help,
is there a way to create some code that will make any black filled cell in
the B colomn run a specific macro when it is clicked on. becuase i have used
this,
If Intersect(Target, Me.Range("b23,b71")) Is Nothing Then
'do nothing
Else
duplicator
End If
to get it to do it on certain cells, but the macro that runs inserts two
rows into the worksheet which then means the cells listed arent actually
relevant to their initial row no's. so it all goes out of sync. so if there
was a way it would only let the click --> macro happen on the black cells
then it cant go wrong!
Thanks,,
WK
is there a way to create some code that will make any black filled cell in
the B colomn run a specific macro when it is clicked on. becuase i have used
this,
If Intersect(Target, Me.Range("b23,b71")) Is Nothing Then
'do nothing
Else
duplicator
End If
to get it to do it on certain cells, but the macro that runs inserts two
rows into the worksheet which then means the cells listed arent actually
relevant to their initial row no's. so it all goes out of sync. so if there
was a way it would only let the click --> macro happen on the black cells
then it cant go wrong!
Thanks,,
WK