Browse codes

Search results 18

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

Thu Jul7 4PM

Cleans file name from invalid unexpected characters that Windows refuses.

Tue Feb22 8AM

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

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

2020Dec5

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Checks if a file can be reached online or no Same as

2019Jun7

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30