using "find" function in macro

[Excelboo2]

I have a script:

Set f = Worksheets("Comparison").Range("b4:b17").Find(a, LookIn:=xlValues, lookat:=xlWhole)

but I found that if the "B" column is hid, "f" has always been nothing. How can I fix it? Thanks

 

[GTO]

AFAIK, you want to unhide the row/column, use .Find, then re-hide.

 

[Excelboo2]

AFAIK, you want to unhide the row/column, use .Find, then re-hide.

Ah yes. But my I know is there any "setting" in the "Find" funcation that can make it capable of searching hid columns? Thanks

 

[GTO]

No, I am afraid not.

 

[brettdj]

No, I am afraid not.

Actually you can use Find with hidden columns by using xlFormulas rather than xlValues, ie

Set f = Worksheets("Comparison").Range("b4:b17").Find(a, LookIn:=xlFormulas, lookat:=xlWhole)

Cheers

Dave

 

[brettdj]

... which I should point out while is fine for hidden columns, will not work on data hidden by filtering

 

[GTO]

ACK! Thank you very much Dave