Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Cell Macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ... 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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to highlight an entire row if a certain value is in a cell | Excel Discussion (Misc queries) | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight Duplicates, Macro? | Excel Worksheet Functions | |||
Macro to Highlight Range | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |