Search results 698

Sorted from new to old.
Card image
COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

Card image
InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

Card image
A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

Card image
GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Card image
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

Card image
NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

Card image
CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

Card image
Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

Card image
Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

Card image
DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

Card image
Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

Card image
Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

Card image
ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

Card image
Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

Card image
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

Card image
ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...