Search results 24

Sorted from new to old.

Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

2025May4

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

2025Apr18

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

2025Apr17

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

1 2