How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...
2021Dec6
How to type special characters in keyboard using ALT + keypad numbers I also ...
2021Oct13
Cuts a string from a string FROM RIGHT starting from specific character and ...
2018Jun2
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
Checks if a number found between two characters, searching can be customized to ...
Aug21
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
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
Formula to show progress to end user from inside two loops. More like an ...
2023Mar7
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...
2018Aug26
Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...
2018Jul14