Search results 46

Sorted from new to old.

ANmExcelTableAddress

Returns reference of a table in Excel workbook. This is because not all tables ...

Fri 9AM

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Apr26

DrawAllAutoShapes

Create new sheet and draw all autoshapes inside. From AI Copilot

2025Nov16

ShapeDelete

Safely remove certain shape from worksheet

2025Sep30

String_Fx

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

2025Apr10

DateAdd_Networkdays

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

2025Apr6

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

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

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

1 2 3