'Evaluate method' category
The Evaluate method converts an Excel name to an object or value. The picture above demonstrates a macro that uses […]
VB for Applications
Functions
Methods
Properties
Statements
VBA
Multiply numbers in each row by entire cell range
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
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup