Search results 30

Sorted from new to old.

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

List_of_Names + DeleteNames

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

2023Jul9

ImportCSVs - 1st AI Code

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

2023Mar20

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

ANmAdvancedFilter

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

2022Sep15

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

ConcaUFO_RowsfromSheets

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

2020Nov11

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Custom Excel Right-Click Menus

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

2020Mar21

Detect if Browser supports Flash

Detect if Browser supports Flash or not ( using ShockwaveFlash.ShockwaveFlash) ...

2019Jun2

UnMergeFill

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

2019Apr16

1 2