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

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

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