getting macro on specific filled cell click
 

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

getting macro on specific filled cell click
 

Consider assigning a Named Range in the worksheet and then testing Intersect
Target with that range.

The Named Range will adjust as rows/columns are added/deleted
--
Gary''s Student - gsnu200735


"bilbo+" wrote:

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