Range.Find Method (Excel) - MSDN - Microsoft

Can be a string or any Microsoft Excel data type. ... Return Value ... in the range A1:A500 on worksheet one that contain the value 2 and changes it to 5. VBA.

msdn.microsoft.com