Search results 156

Sorted from new to old.

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

Convert_Dash_to_Zero

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

2023Mar14

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

LstCustomSelection_Refresh

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

2022Aug31

AddDatabar_ConditionalFormatting

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

2022Aug22

SettingNameAlreadyFound

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

2022Aug18

LastRow_Remove

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

2022Aug16

Export2CSV

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

2022May16

1 2 ...6 ...9 10