Runtime error '91'

[akabraha]

Hello,

I am trying to use Find function to locate a specific cell with the following code

Please Login or Register  to view this content.

Problem is, when I hide the column B, it doesn't work and gives me an error:

Runtime error '91'. Object Variable or with block variable not set.

If column B is not hidden, it works just fine, column B is used for just reference, that's the reason why I have this column as hidden. Is there any way to fix other than un hiding column B?

Thanks, Anil

[FrankBoston]

In my tests, hiding the column did not change anything.

Not finding any matching cells in the .Find did give the Error 91.

[Greg M]

Hi All,

I had the same problem as Anil - maybe it's to do with the Excel version - Excel 2000 here.

Anyway, to avoid the runtime error just use the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Best regards,

Greg M

[akabraha]

Thanks a lot Greg et al. Sorry for the delay in responding back. My problem solved.

[Greg M]

Hi again Anil,

Many thanks for the feedback. You're welcome - delighted to have helped.

Regards,

Greg M