Highlight Cell Macro

  • Thread starter Thread starter palley
  • Start date Start date
P

palley

: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
 
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
 
Back
Top