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 ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
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
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
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
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
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
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...
2018Jul7
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
Counts how many words found inside a string. Using space, tab or enter as ...
2019Mar31
PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic
2019Feb8
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
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 ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Enable relative paths for ASP Classic includes to work. New servers do not ...
Aug7
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16