ImportCSVs - 1st AI Code

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

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

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

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

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

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first