In this tutorial, you will learn how to search for data in your excel file using macros. this Technique could be faster than going through each row and searching for the information (as we have done in past lessons).
Firstly, we will look at the parameters of the find functions, especially:
1) What you are looking for
2) Whether to look in comments, values, notes or formulas
3) Whether to search for an exact or partial match
4) If caps matter
Second, we will use the IF statement to avoid errors if matches are not found
Thirdly we will get look at the code to:
1) Get 1 match
2) Get multiple matches
Link to workbook: mega.nz/file/KXxAlIBK#ioMxwvh...
if: • 016. Practical use of ...
For and While Loops: • 009. FOR Loop, WHILE L...
VBA if: • 009. FOR Loop, WHILE L...
Channel content: Excel, excel tutorial, Microsoft excel, learn excel, how to use excel, excel basics, basic excel, ms excel, office 365, excel for dummies, excel functions, learn excel basics, microsoft excel for beginners, excel course, Mr Excel, excel help, microsoft excel tutorial, excel tricks, excel tips, excel guide, how to in excel, tricks in excel, tips and tricks, pivots tables, excel formulas, advanced techniques for excel.
#Excel #MsExcel #ExcelMacro
Негізгі бет 014. Excel VBA FIND function Example (Not found, 1 match and multiple matches)
Пікірлер: 14