Search results 204

Sorted from new to old.

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Dec4

ANmaRemoveDuplicates4

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

Dec4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Nov17

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

Oct6

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

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Feb23

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Feb14

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

1 2 ...12 13