Find Function Error

[Steve0492]

Hello,

I am trying to use the .Find function and am encountering an error. Below is my code. Does anyone know what is wrong? Thanks!

Please Login or Register  to view this content.

[Norie]

As far as I know Find can't be used with an array of worksheets.

[Steve0492]

I see. In that case, does anyone know of a work around for using the Find with an array?

[jeffreybrown]

Hi Steve,

Not sure if this is what you are trying...

Run Sub testfound()

[Steve0492]

Perfect Jeffrey. Thank you for the quick and helpful response!

Steve

[jeffreybrown]

You are very welcome Steve and thanks for the feedback.