how to make cell selection light up whole row

[novice2430]

Is there a way to light up a row when a cell in that row is selected?
I'm working within columns A through H.

[pike]

hi novice2430
Try this code

Please Login or Register  to view this content.

[JBeaucaire]

A slight adaptation to fit the OPs request for columns A:H only.

Please Login or Register  to view this content.

NOTE: A sheet macro like this will remove any formatting in those columns.

Right-click on the sheet tab name and select VIEW CODE, paste in the macro above.

[novice2430]

Thanks for the quick response.
JBeaucaire,
I used your code, but I had problems when I extended the columns to K for another worksheet.
When I Select a cell within A:K there's color left in I,J,and K.
I've attached a sample.

[JBeaucaire]

There are THREE instances where the range is referenced, you only changed two of them:

Please Login or Register  to view this content.

[novice2430]

Oh Okay,
That's why leave the VBA to people who know about it...lol
Well Thanks for taking a look and solving my problem.