add range in find method

[ilkamalo]

hi, i need to put the line below in the macro so that it can be more efficient
(instead of searching in the whole sheet it search in the range that i mention)

many thanks

Range(Cells(firstrow, firstCol), Cells(lastrow, lastCol)).Select

Please Login or Register  to view this content.

[StephenR]

This perhaps?

Please Login or Register  to view this content.

[ilkamalo]

thank you ,very much;that's it.

This perhaps?

Please Login or Register  to view this content.