Search results 24

Sorted from new to old.
Card image
Tabs-Auto-To-Menu

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

Card image
MatchIf7Up

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

Card image
FirstDuplicatedItem

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

Card image
ANmaRow_Duplicate1

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

Card image
Excel recovered files

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

Card image
Range2Block

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

Card image
ANStr2Range

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

Card image
ASP Classic Page Cache

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

Card image
BooleanCount

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

Card image
DynamicFill

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

Card image
Fill down

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

Card image
IsError_Range

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

Card image
Special chars

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

Card image
HTMLTagAttributeValue

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

Card image
ShapeRange_BG

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

Card image
Regular expressions (Notepad++)

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