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