Hello jetted.

Thanks for the reply and looking at this.

I dont think that will do it.

But I did notice that my xyz_rows should be range and not long. So thanks for that tid bit.

So now I am trying this and it doesnt work:
    Dim xyz_rows As Range
    Set xyz_rows = Sheet5.Range("C:C").Find("example", , xlValues, xlWhole, xlByRows, , True).Resize(3, 1)
    Sheet5.Range(xyz_rows).EntireRow.Hidden = True
I get error 1004. Method 'Range' of Object'_ worksheet; failed.