Hi Guys, hope this should be a quick one,

I'm using the Find function in VBA on a column of data, but the range is being set to Nothing if the data item I'm looking for happens to be in a row that is hidden at the time.

How do I set the find to look in all rows, hidden or not?

Can this be done without unhiding all the rows first?

Thanks,

Ian

I'm using the Find function in VBA on a column of data, but the range is being set to Nothing if the data item I'm looking for happens to be in a row that is hidden at the time.

How do I set the find to look in all rows, hidden or not?

Can this be done without unhiding all the rows first?

Thanks,

Ian

## Comment