VB for Applications
Functions
Methods
Properties
Statements
VBA
Count text strings in formulas [VBA]
Copy worksheets in active workbook to new workbooks
Create comment if cell value is larger than column
Weekly Blog EMAIL
Get a FREE PDF book!
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Filter words containing a given string in a cell range [UDF]
The image above demonstrates a User Defined Function that extracts all words containing a given string that you can specify. In […]
How to extract email addresses from an Excel sheet
Question: How to extract email addresses from this sheet? (See pic below) Answer: It depends on how the emails are […]
English
Spanish