Search results 204

Sorted from new to old.

ANmaCellFormat

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

Apr18

MatchIfUp or MatchIfRev

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

Apr8

NumberNumberNumber

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

Mar2

VBInstr_Numeric

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

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

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

gsplit usage

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

Feb7

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

Jan6

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ChartLabelsNumberFormat

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

2023Dec23

1 2 3 ...12 13