Highlight Cell Macro
 

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

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

Highlight Cell Macro
 

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
...

:confused: 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/