Browse codes

Search results 35

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

Aug10

Returns True if found as full, False if not found as full Full word means word ...

Jul24

Add st, nd, rd or th to end of number, can be used for dates also

May3

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

Apr23

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

Apr14

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Mar20

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

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

2022Sep15

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

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

2022Jul3

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23