VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

UnProtect.zip