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