Problem with Code to "Click to highlight cell"

Hi all

I have a bit of code that highlights a cell when clicked (pasted below) and I have attatched to an "on/off" button. I apologize in advance for not knowing the correct terms for everything.

This is the portion in the "sheet 1" macro window:

Please Login or Register  to view this content.

and this it the portion in "module 1":

Please Login or Register  to view this content.

so the problem is that I need to paste a large table table into the workbook and when I do and try to use the "highlight Macro" I get an error saying "subscript out of range" and it references this line in the code.

Please Login or Register  to view this content.

Any help in the right direction would be appreciated, thanks!

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Hi lp116 and welcome to the forum,

I have a favorite site that speaks to Event Code. I think you should start by reading it.
http://www.cpearson.com/excel/Events.aspx

Please Login or Register  to view this content.

xlNone is a special value of -4142 (same as xlColorIndexNone). When you start doing arithmetic on this to get other color index values you are going to get invalid values. ColorIndex is valid in the range 1-56. When you add -4142 to any color index you will get a negative value, which is invalid (unless the result is exactly -4142).

So this leads me to ask what are you trying to do with that statement?