Codes Required
QuickEncrypt plus others ...
Text encryption/decryption snippet that utilizes the powerful xICE encryption ...
Aug15
ANmaSearch_SpaceFriends and LeftSpaceFriends
Searches for string inside string covering multiple possibilities for space ...
Jul30
ANmaSearch_OrFriends
Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...
Jul30
Quarter1stLastDate_FromQuarterText
Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...
Jul26
ANmaSpecialFolders
Returns path for a specific special folder in system Passing the name of that ...
Jul26
ANmaSearch_AposFriends
Searches for string inside string with apostrophe possibility (or as I call ...
Jul11
ANmaSearch_AmpFriends
Searches for string inside string with multiple possibilities if the char & ...
Jul7
ANmaSearch_ApostropheFriends
Searches for string inside string with apostrophe variations conversion
May27
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Associate_Ext
Register an extension in Windows registry for extension with an application. ...
Nov25
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
ReadLastChars
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
ASPUsers
Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...
2022May4
Range_SaveAsImage
Exports range to an image, something we wanted to be able to do for a while now. ...
2022Feb16
SaveAsHTML_Template
Creates HTML file using template found in a column. Have lines of HTML in a ...
2022Feb5
Base64encode + Base64decode
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Similar codes
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Range_Add_or_Subtract
Adds an amount (or subtract) from a range of cells in one click
Similar to
2023Feb18
merge2Arrays
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
NMRRank_v2021
Ranks a number among set of numbers. This is part of huge tool, we needed to ...
2021Sep23
UnMergeFill
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
Recently by developer
HTMLCloseTag_HasWordAfter
Finds the number of occurrence of a "Numeric" inside a string having a certain ...
Sun 4AM
CountColumnCells_Unique
COunts unique cells found in a column. Passing sheetname, workbook name and ...
Sun 4AM
Walking Columns (Scrollable Columns-Chart)
Allow users to scroll through columns in column-chart. Used chart.js, this is ...
Sep30
Random Codes
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
GetRandom
Generate random string, fully customization, with even deciding what special ...
2018Apr21