Use cell reference instead of text in VBA

[andrewb90]

Hello all!

I have this portion of code that seems to work, however I need instead of a fixed item like "California", I need it to reference a sheet and a cell instead. I feel like everything I've tried isn't working, and its probably something super simple that I'm doing wrong.

    For Each c In Range("C2:C50").Cells
        If c.Value <> "California" Then
            c.EntireRow.Hidden = True

        End If
    Next c

 

[nemmi69]

you could simply replace "California" with something like range("Z1").value (assuming Z1 was your reference cell.

 

[andrewb90]

you could simply replace "California" with something like range("Z1").value (assuming Z1 was your reference cell.

See thats what I thought. I put it in and it works on my test worksheet. Then I transfer it to my bigger worksheet and it doesn't work. It's confusing...

 

[nemmi69]

It will depend if, when you use it, if you are on that worksheet or on another. If your on another then it needs Worksheets("nameofsheet").Range("Z1").Value