Methods
Excel ยป VBA ยป Methods ยป
How to use the EVALUATE method
The Evaluate method converts an Excel name to an object or value. The picture above demonstrates a macro that uses [โฆ]
How to use the RANGE.FIND method
The Range.Find method returns a range object for the first cell that matches the lookup value. Macro used in workbook above The [โฆ]