Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
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
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
Checks if number between two numbers, with or without considering those numbers. ...
Mar23
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
Looks like we cannot have filename (having no extension) and folder in same ...
Mar5
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
Downloads list of domains and prices for register, renew or transfer into ...
2018May25
Download a file from URL from inside Excel into certain path, returns blank if ...
2018May22
Shows an image after clicking on its thumbnail, like in web applications Can ...
2018May20
VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...
2018May16
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...
2018Aug23
List names in a certain workbook into sheet. And Deletes those names. You may ...
Jul9
Gives your user ability to select a workbook from list of open workbooks within ...
2019Apr3
During generating Print Preview, Excel crashes. Applies to some files, not all, ...
2021Mar6
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Get relative path of one to another Pass two path strings to this function and ...
2018Jul19