Search results 35

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

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

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

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

1 2 3