You will end with code like shownĬells.Find(What:="Cat", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ The single best way to get the code needed for the Find Method is to recordĪ macro using it on any Excel Worksheet. Range where the value being sought resides. The Range Object returned will of course be the Also, a Range Object is returned whenever Where " expression" is any valid range Object, e.g. SearchDirection, MatchCase, MatchByte, SearchFormat) Find(What, After, LookIn, LookAt, SearchOrder, The syntax for the Find Method is as shown below Įxpression. Unfortunately most end up using a VBA loop instead of the Find The Excel Find Method is an excellent tool to use when writing Excel VBA
0 Comments
Leave a Reply. |