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 ...

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 ...

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

UnProtect.zip

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

Frm9.zip

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...