Limit the search range in FIND() function

Hi,

I am currently using the simple code block below to jump to a cell on another sheet based on a user-inputted value to a cell on the current sheet. Although jump is too strong a word at the moment...walk slowly might be more appropriate.

The problem is that the sheet that contains the target cell hosts a very sizable used range and the FIND function can sometimes take almost a minute before finding and focussing on the required cell.

While I do not believe that a search range below that of sheet level for the FIND() function is possible, the cell that I am looking to jump to resides in a one-column, sorted, dynamic named range (=Bookings!JobID) on the target sheet, so I am sure that it must be possible to find and go the target cell in a much quicker timeframe than that being delivered at the moment. Just can't find something suitable at the moment.

Maybe something using VLOOKUP or GOTO might be possible? Any advice appreciated.

Thanks in advance as ever.
Orson.

Please Login or Register  to view this content.

Orson100 try to limit the search area

Please Login or Register  to view this content.

oops,

tested code

Please Login or Register  to view this content.

no problem remember to mark the post solved