MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

Shortner

Create a URL shortner using Web.Config AKA URL Redirect, or Page refresher, ...

Content.zip

CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

Shortcuts (rundll32.exe)

Shortcuts to do certain commands in Windows (tested in Windows 7) Shutdown, ...

This Year

A quick JS way to get the year of today, a method found it online, and wanted ...

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

Listbox height changing issue.zip

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...

SwapDate

Changes date format from US to International or from international to US. ...

MyMonthName

Returns the month name in one of 5 formats (below) It can use full date or ...