Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting only filtered rows
hi, not sure if this is possible, but i have a large range of unique dat which i filter through. when i perform a search for a single row an all other rows are hidden, i'd like to highlight the single filtere row in yellow. is this possible with a macro? any ideas? thanks, Fran ----------------------------------------------- ~~ 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
|
|||
|
|||
highlighting only filtered rows
Autofilter?
set rng = Activesheet.AutoFilter.Range set rng = rng.offset(1,0).Resize(rng.rows.count-1) set rng1 = rng.Columns(1).SpecialCells(xlVisible) if rng.count = 1 then rng.Resize(1,rng.columns.count).Select ' or ' rng.Resize(1,rng.columns.count).Interior.ColorInde x = 5 End if Not sure what you mean by highight. First option selects the row, second colors it. -- Regards, Tom Ogilvy "fgatch" wrote in message ... hi, not sure if this is possible, but i have a large range of unique data which i filter through. when i perform a search for a single row and all other rows are hidden, i'd like to highlight the single filtered row in yellow. is this possible with a macro? any ideas? thanks, Frank ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting only filtered rows
try Sub colorvisiblerows() With Rows("1:" & Range("a" & Rows.Count).End(xlUp).Row) .Interior.ColorIndex = xlNone .SpecialCells(xlCellTypeVisible).Interior.ColorInd ex = 6 End With End Sub -- Don Guillett SalesAid Software "fgatch" wrote in message ... hi, not sure if this is possible, but i have a large range of unique data which i filter through. when i perform a search for a single row and all other rows are hidden, i'd like to highlight the single filtered row in yellow. is this possible with a macro? any ideas? thanks, Frank ------------------------------------------------ ~~ 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 | |||
Highlighting Rows with VB. | Excel Worksheet Functions | |||
Highlighting headlines filtered column when using autofilter | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
Highlighting Filtered column | Excel Discussion (Misc queries) |