Codes Required
Similar codes
WorkbookOpen_ANmar
Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Between_2Chars
Returns if a char was found between two defined characters. Like find if Loss ...
Nov22
List_of_Names + DeleteNames
List names in a certain workbook into sheet. And Deletes those names. You may ...
Jul9
Excel user name
Get application user name or change it
Originally from
Jun14
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
GetColumnIndex
Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...
2021Nov26
ProtectFile_XorD + UnProtectFile_XorD
Protects and unprotects a file using password Creates another copy of the file ...
2020Jan10
tAutocomplete
Dropdown list for input box works as Autocomplete Multi-column, themeable ...
2019Jun25
Find and Replace
This will find all occurences of a string in a text file and replace it with ...
2018Apr15