Search results 390

Sorted from new to old.

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

ReturnLongestString_Of2

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

2024Jul2

ANmAdd_ThenSort_2Columns

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

2024Jun1

Microsoft Edge gestures

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

2024May27

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

2024May27

ANString_Location

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

2024Apr23

SortArea4

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

2024Apr15

Concatenate_HTMLColumn

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

2024Mar14

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

OneDrive Reset

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

2024Mar5

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

HTML_InsideTag_ByIndex

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

2024Feb28

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

1 2 3 ...24 25