Browse codes

Search results 68

Imports a range into 2-dimension array. Returns the array, providing range, ...

May11

3 functions to add or update data to DB and Read from DB. These were also ...

Apr23

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

Mar14

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

Mar6

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

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

2022Nov11

Removes duplication in table in 1 or more columns. Will work in sheet, ...

2022Sep25

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

2022Sep1

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

2022Aug16

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

2022Jul19

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