Search results 47

Sorted from new to old.

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Apr6

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

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

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

VBInstr_Numeric

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

2024Feb25

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

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

COUNTIFS as Rank

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

2022Jan1

1 2 3