Codes Required
Similar codes
AddressReferenceStyle
Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...
Nov1
ANmAddressRefStyle
Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...
Sep23
HTMLPadding_or_Margin
Finds the padding or margin from a style statement for an HTML tag. Passing ...
Jan5
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Styles_DeleteNonStandard
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Recently by developer
HTMLCloseTag_HasWordAfter
Finds the number of occurrence of a "Numeric" inside a string having a certain ...
Oct6
CountColumnCells_Unique
COunts unique cells found in a column. Passing sheetname, workbook name and ...
Oct6
Walking Columns (Scrollable Columns-Chart)
Allow users to scroll through columns in column-chart. Used chart.js, this is ...
Sep30
Random Codes
AskForFolder
Asks user to assign a folder, been looking for something like this for awhile ...
2023Mar23
Bootstrap IE issue
Looks like IE has some issues in bootstrap 3, this is the solution, please ...
2019Jan11
TimeRound
Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...
2018Jun25
DB_Setting1List + DB_Setting1List_NameValue
DB_Setting1List is to Returns list of SettingValues matching certain ...
2018May31