Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the parent row of a cell in VBA
If I have a reference to a particular cell, is there a way getting a
reference to the row which contains that cell? Essentially what I want to do is filter a worksheet based on a list of values For Example for each cell in column if cell.value = Not some_value then hide row containing current cell end if next cell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the parent row of a cell in VBA
for each cell in column
if cell.value = Not some_value then cell.entirerow.hidden = true end if next cell -- HTH Bob Phillips "Andrew Marshall" wrote in message ... If I have a reference to a particular cell, is there a way getting a reference to the row which contains that cell? Essentially what I want to do is filter a worksheet based on a list of values For Example for each cell in column if cell.value = Not some_value then hide row containing current cell end if next cell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the parent row of a cell in VBA
Many Thanks.
Andrew. "Bob Phillips" wrote: for each cell in column if cell.value = Not some_value then cell.entirerow.hidden = true end if next cell -- HTH Bob Phillips "Andrew Marshall" wrote in message ... If I have a reference to a particular cell, is there a way getting a reference to the row which contains that cell? Essentially what I want to do is filter a worksheet based on a list of values For Example for each cell in column if cell.value = Not some_value then hide row containing current cell end if next cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding loops in parent/child relationships | Excel Discussion (Misc queries) | |||
Parent of the embeded excel | Excel Discussion (Misc queries) | |||
finding multiple parent-child relationships? | Excel Worksheet Functions | |||
Sorting Parent Child | Excel Worksheet Functions | |||
MultiPage Parent Name | Excel Programming |