BoldCodes

Search results 64

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

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

2022Aug22

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13