Codes Required
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
XLShortcut_EnableDisable
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
ExcelMenu_onfly
Creates Excel menu on the fly, list of menu items, command actions, and icons ...
2018Jul17
Similar codes
UnBreakAr + BreakAr
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
Excel 2010 hyperlink issue fix
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
User-defined type error
How to fix error (User-defined Type) error, especially when using outside ...
2019Feb1
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Max + Min + Min_No0s
Calculate maximum of array of numbers or Minimum of array of numbers Also, ...
2019Dec31
Subtotal_Indirects
Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...
2021Nov26
Nautical/Flight Functions
Functions perform various calculations useful for planning trips. MPH2Kt: ...
2020Oct13
O365 Blocked Macros
Recent Microsoft 365 Excel blocked macros from running when they are in ...
Jul10
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Associate_Ext
Register an extension in Windows registry for extension with an application. ...
Nov25
ANBSThumbImg + ANBSThumbLink
Creates thumb of an image with or without link to original Use ANBSThumbLink ...
2019Dec1
UnMergeFill
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16