BoldCodes

Search results 400

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

Creates batch file with certain content, and another function to actually ...

2022Aug25

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7