Search results 43

Sorted from new to old.

ShapeDelete

Safely remove certain shape from worksheet

Sep30

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

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

Range_SaveAsImage

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

2022Feb16

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

1 2 3