.find Function Failing

Hi, Centexcel,

Number as Text:

Formula:

'4010

In the code you provided you select a sheet, do some Copy&Paste and then do the search - maybe thatīs the key to why you wonīt find the item on other sheets.

keyrange builds up the correct area: $A$1:$A$291 - one of the first checks I did on the code. No need to go for a full column there IMHO.

Ciao,
Holger