Find Function Parameters work if recorded but not if written?

[noboffinme]

Hi Forum,

I'm writing a Macro to search through several Worksheets for a Value.
I've recorded the code using the Find Function & changing some of the parameters to get more exact results.
Example, the values I'm searching for are exactly what should appear in a Cell & be in the same case, so I've made those changes in the Find Dialogue box when I recorded the Macro.
My issue is that when I try to paste the same Macro the parts that cause errors are the 'LookAt :=Whole' and the 'MatchCase:=True' in the Find Parameters?

Here's my code & the data I'm using is a worksheet where the Value 'EMP' occurs randomly.

Either one will throw an error, & I wondered if anyone knows why & also how to fix this?

Thanks Peter

Please Login or Register  to view this content.

[jindon]

It occurs when Find method has no result.

Please Login or Register  to view this content.

[MarvinP]

Hi Peter,

What would this macro do?

Please Login or Register  to view this content.

Perhaps your Selection doesn't go to the cell you want??

[noboffinme]

Thanks jindon, works fine.

[noboffinme]

Thanks MarvinP, yours also works fine, Thank you.