Search results 129

Sorted from new to old.

ANmaRow_Duplicate1

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

Thu 5PM

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr11

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

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

Apr2

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

SSL/TLS certificate add/update

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

2024Nov7

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

CountColumnCells_Unique

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

2024Oct6

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

2024Aug15

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

ANStr_Add10IfNotBlank_NorNA

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

2024Jul24

1 2 ...8 9