Similar codes
GetFilename, GetExtension, .. others
GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...
2018Jun11
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
UnBreakAr + BreakAr
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
Excel crashes when File > Print
During generating Print Preview, Excel crashes. Applies to some files, not all, ...
2021Mar6
jQuery.timeline
Great horizontal timeline jquery
From
2019Jul11
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Protect VBA
Protect VBA project from inside VBA This is the raw way, there has to be other ...
2019Jan1
UnBreakAr + BreakAr
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
VBA Progressbar (Frm73)
Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...
2018May16