VB for Applications
Functions
Methods
Properties
Statements
VBA
Multiply numbers in each row with remaining rows in cell range (UDF)
How to save specific multiple worksheets to a pdf file programmatically
Find literal values in formulas
How to create a list of comments from a worksheet programmatically
How to highlight row of the selected cell programmatically
Count text string in all formulas in a worksheet [VBA]
Copy worksheets in active workbook to new workbooks
Create comment if cell value is larger than column
In this post I will describe a basic user defined function with better search functionality than the array formula in […]
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup