Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
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
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
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
Tell App to wait for number of seconds and Execute command and wait for it ...
2018Jun16
Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.
2020Feb9
Execute any command in Excel VBE, using Application.Evaluate to execute almost ...
2020Feb16
Logs out Linkedin by running two commands One will open new window to logout ...
2018Apr23
Get output of DOS Command in string, by reading output into temp text file, ...
2018Jun22
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...
2018Aug8
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16