VBA-Excel 380
Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
ConcaUFO_RowsfromSheets
Imports rows from multiple sheets of a workbook into final sheet along with ...
ExitTool and DoNothing
My way of Exiting tool in case or error, also another sub that basically does ...
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
Part of cells in Excel
How to modify part of text inside an Excel cell using VBA. Something in my ...
UI_2ValidationsUpdate
Apply validation on two cells, when a 3rd cell is changed When modifying a ...
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
Custom Excel Right-Click Menus
Customizing Excel's right click menus The following code demonstrates how to ...