Search results 607

Sorted from new to old.

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

ANmAdd_ThenSort_2Columns

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

Jun1

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

Microsoft Edge gestures

Microsoft Edge Right-mouse gestures I found that will really save me time ...

May27

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

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

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15

SortArea4

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

Apr15

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

Mar5

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Mar5

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Feb28

1 2 ...37 38