Because the search starts AFTER this cell, the specified cell is searched right at the end. Īfter: This represents a single cell which you will specify, AFTER which the search begins. What: Is the item or value which is searched.

or cover all cells of a worksheet: ActiveSheet.Cells, and so on.

You can search within specific cells viz. RangeObject represents a range in which the specific item or value is searched. Only the What argument is necessary to specify, all other arguments are optional. RangeObject.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat) matching cell) is found, it returns Nothing. the first cell, where the item or value is found. To search for a specific item or value in a range, use the Find Method which returns the Range, ie. Using Excel Find Method to Search for a Date Find Method in Excel VBA, Find Multiple Occurrences, Use Find Method to do Vlookup, Find Method to Search Dateįind multiple occurrences of an item or value in a range

Find a range in excel vba