Codes Required
Similar codes
strUnQuote
This will tests to see if strQuotedString is wrapped in quotation marks, and, ...
2018Jul3
Remove_Between2Quotes
Remove any char (or string) found between two quotes in a string This is an ...
2020Mar9
ForegroundColor
Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...
2023May5
FGColor_Calc
To set the color of the foreground based on background color to get best look. ...
2018Jun20
ProtectText + UnProtectText
Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...
2018Jul19
OpenPassword + ClosePassword
Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...
2018Jun14
HTMLTag + HTMLPair
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Progress in two nested loops
Formula to show progress to end user from inside two loops. More like an ...
2023Mar7
InSheet_ChangeImage
Allows users to inserts image into sheet, replacing old one, with ability to ...
2021Feb20
PCase (ProperCase)
Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...
2018Aug8