VBA Snippets
SUMPRODUCTIF function for Excel
last update: June 19, 2017
Return to original active sheet at end of macro 1,141 views
Combine the data from two sheets 71 views
Find the last used ROW in a sheet 82 views
Replace IFERROR() with IF(ISERROR()) 198 views
Send email to excel list of recipients 139 views
Use defined name from document inside VBA 71 views
Get the URL from a hyperlink in Excel 124 views
Update header and footer on all sheets in a workbook 86 views
Add ERROR trap: Wrap all your formulas in IFERROR or ISERROR 803 views
Get the title from a URL 1,766 views