Codes Required
Similar codes
AddressReferenceStyle
Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...
Nov1
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Range_Add_or_Subtract
Adds an amount (or subtract) from a range of cells in one click
Similar to
2023Feb18
Special chars
How to type special characters in keyboard using ALT + keypad numbers I also ...
2021Oct13
CountDuplicates
Counts how many duplicates found in a range of Excel cells. Basically how many ...
2020Oct31
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
Progress in two nested loops
Formula to show progress to end user from inside two loops. More like an ...
2023Mar7
A is for Alpha
Military way to communicate letters in audio, for me I learned not all required, ...
2021Dec6
User-Defined Formatting
Apply special Conditional Formatting, color cells based on their values. This ...
2019Jan9