Excel VBA Notes for Professionals2018 | ISBN: N/A | English | 128 pages | PDF...
Chapters:
Getting started with Excel VBA
Arrays
Conditional statements
Ranges and Cells
Named Ranges
Merged Cells / Ranges
Locating duplicate values in a range
User Defined Functions (UDFs)
Conditional formatting using VBA
Workbooks
Working with Excel Tables in VBA
Loop through all Sheets in Active Workbook
Use Worksheet object and not Sheet object
Methods for Finding the Last Used Row or Column in...