Browse codes

Search results 76

Copy values from range to cell. Without using clipboard of course. Here the ...

Aug10

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

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

Removes duplicated emails in an outlook folder. Originally not my work, ...

Jan1

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

2022Sep25

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

2022Aug16

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

2022Jul7

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

2022Jul4

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

Create list of unique items from a column into another column This is similar ...

2022Apr26