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:
I get error 1004. Method 'Range' of Object'_ worksheet; failed.![]()
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
Bookmarks