Search results 971

Sorted from new to old.

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

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

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

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

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr3

Concatenate_HTMLColumn

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

Mar14

CopyFiles Excel-Macro

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

Mar12

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

FindAncherURL_InHTMLRow

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

Mar4

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

1 2 ...6 ...60 61