I am trying to create a custom function attached to a graphic which will allow for the contents of a range (on a single row) of cells to be cleared when activated. I would like to be able to perform this function on every row in my worksheet. How do I make this code and can i just copy and paste onto each row?
Example: When I activate graphic in cell A2, contents of cells B2:J2,M2 are deleted.
When I activate graphic in cell A3, contents of cells B3:J3,M3 are deleted.
And so on....
Example: When I activate graphic in cell A2, contents of cells B2:J2,M2 are deleted.
When I activate graphic in cell A3, contents of cells B3:J3,M3 are deleted.
And so on....