| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting rows when a value has been found
hi,
i am using the find method, and at present it highlights only the value that i have asked it to found. i would like it to highlight the entire row or column where the value lies. is this possible? look forward to your replies. thanks mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
highlighting rows when a value has been found
lots of options, depending on how you want to highlight the row but the
simplest might be..... Rows(Activecell.Row).Select -- Cheers Nigel "mike" wrote in message ... hi, i am using the find method, and at present it highlights only the value that i have asked it to found. i would like it to highlight the entire row or column where the value lies. is this possible? look forward to your replies. thanks mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
highlighting rows when a value has been found
or simpler/more intutitive
activeCell.Entirerow.Select -- Regards, Tom Ogilvy "Nigel" wrote in message ... lots of options, depending on how you want to highlight the row but the simplest might be..... Rows(Activecell.Row).Select -- Cheers Nigel "mike" wrote in message ... hi, i am using the find method, and at present it highlights only the value that i have asked it to found. i would like it to highlight the entire row or column where the value lies. is this possible? look forward to your replies. thanks mike |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
highlighting rows when a value has been found
Mike,
Select row or column .... With Worksheets(1).Range("a1:a500") Set c = .Find("B", LookIn:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do Rows(c.Row & ":" & c.Row).Select Columns(c.Column).Select Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With HTH "mike" wrote: hi, i am using the find method, and at present it highlights only the value that i have asked it to found. i would like it to highlight the entire row or column where the value lies. is this possible? look forward to your replies. thanks mike |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
highlighting rows when a value has been found
thanks for that.
mike "Toppers" wrote: Mike, Select row or column .... With Worksheets(1).Range("a1:a500") Set c = .Find("B", LookIn:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do Rows(c.Row & ":" & c.Row).Select Columns(c.Column).Select Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With HTH "mike" wrote: hi, i am using the find method, and at present it highlights only the value that i have asked it to found. i would like it to highlight the entire row or column where the value lies. is this possible? look forward to your replies. thanks mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Highlighting Rows with VB. | Excel Worksheet Functions | |||
| Found Cell Highlighting after Search | Excel Discussion (Misc queries) | |||
| Highlighting Found Text in Excel | Excel Discussion (Misc queries) | |||
| highlighting rows | Excel Programming | |||
Hybrid Mode
