Search results 208

Sorted from new to old.

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Nov10

ANmAddress_Dimensions

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

Nov8

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

Nov7

ANmAddress_Value

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

Oct31

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

Oct29

RoundUp2

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

Oct1

ANmAddressSame

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

Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep23

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Aug21

HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

Aug19

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

Aug15

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Aug11

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Jul28

Unblock blocked macros.

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

Jul27

DateDiff_Networkdays

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

Jul25

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

1 2 ...12 13