Search results 563

  2. Search results
  3. work
Sorted from new to old.
Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10
Card image
ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8
Card image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2
Card image
ANmAddress_Value

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

2024Oct31
Card image
MaxOfArray

Gets the maximum number from an array. Like

2024Oct24
Card image
CountColumnCells_Unique

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

2024Oct6
Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1
Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10
Card image
QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

2024Aug15
Card image
Code128.js

Pure JavaScript library for generating barcodes using HTML5 canvas.

2024Aug13
Card image
HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

2024Aug4
Card image
Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27
Card image
DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25
Card image
JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6
Card image
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

2024May27
Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1
12...3536