Search results 266

Sorted from new to old.

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

Tue 4AM

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Mon 1PM

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Mon 1PM

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

Apr2

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

Animated placeholders

White and dark animated placeholders to be used in websites. I needed to ...

2024Dec9

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

ANmAddress_Dimensions

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

2024Nov8

ANmAddress_Value

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

2024Oct31

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

RoundUp2

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

2024Oct1

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

1 2 ...16 17