Search results 38

Sorted from new to old.

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

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

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

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

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

1 2 3