BoldCodes

VBA-Excel 281 Visual basic for applications that works only in Microsoft Excel, aka macros

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

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

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

2022Aug16

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