Search results 41

Sorted from new to old.

Match6_Until

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

Nov28

ANmAddress_Value

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

Oct31

MaxOfArray

Gets the maximum number from an array. Like

Oct24

CountColumnCells_Unique

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

Oct6

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

VBInstr_Numeric

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

Feb25

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

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

ConcaUFO_RowsfromSheets

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

2020Nov11

1 2 3