Codes Required
Similar codes
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
Grandchildren files and count
Returns list of files in 2 level folders Will not find files as children of ...
Jan11
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
SortedFiles
Get a sorted list of files in a directory using the File System Object (FSO) ...
2020Aug11
Frm6 - ANmaMultiSelect
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
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
Random Codes
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
ConvertMultiLine2 + 6
Convert text blocks (by converting line separators from any separator to any). ...
2018Jul11
FileDate_Formatted
Returns a formatted version of file 'LastModified' date. Pass parameter ...
2018Apr25