Search results 519

Sorted from new to old.

MatchIf2Up

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

Apr29

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

SortArea4

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

Apr15

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

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

Just learnt that now

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

Mar5

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

HTML_InsideTag_ByIndex

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

Feb28

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

SwitchTextinCells

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

Feb23

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

Feb15

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

1 2 3 ...32 33