Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Creates square thumb for an image, regardless of image aspect ratio It will ...
Jan18
Saves txt file as word doc with password. Passing txtfile having full path and ...
Jan4
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...
2018Aug10
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
Thanks to new law in Europe, we need to show users and let them accept a ...
2018Jul6
Generate random string, fully customization, with even deciding what special ...
2018Apr21
Reads content of Page from URL to a sheet. This was made specially for certain ...
2023Apr4
Looks like IE has some issues in bootstrap 3, this is the solution, please ...
2019Jan11
Return id for any html tag that was found above certain location of html page. ...
Feb2
Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...
2020Jan22
Reads content of webpage with optional post data
two main differences from
2023Jan14
Testing step in site (or in each HTML output function to replace < with < ...
2021Jun9
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Finally, can have one command to open any file using its default associated app ...
2022Jan28
In-place editing with Twitter Bootstrap, jQuery UI or pure jQuery.
From
2019Aug31
SQL function to generate random string I thought it would be easier to find ...
2019May5