finding the parent row of a cell in VBA

[Guest]

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

 

[Bob Phillips]

for each cell in column
if cell.value = Not some_value then
cell.entirerow.hidden = true
end if
next cell

 

[Guest]

Many Thanks.

Andrew.

for each cell in column
if cell.value = Not some_value then
cell.entirerow.hidden = true
end if
next cell