palley,

There are probably more concise ways to do this, but.....

Sub TestMe()
Range(Range("A" & ActiveCell.Row), _
Range("E" & ActiveCell.Row)).Interior.ColorIndex = 6
End Sub

should work just fine.
Just assign your button to this macro.

John

"palley" wrote in message
...

I have a spreadsheet with info in abot 100 rows and columns
A thru E. I want to be able to click on a row and have a macro button
that would highlight that row cells A thru E. I know I can highlight
the cells and click on the fill color but I would rather use a macro
button. I tried a macro using activecell but it only highlighted column
A. .............HELP


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/