Search results 184

Sorted from new to old.

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Special chars

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

2021Oct13

NMRRank_v2021

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

2021Sep23

CleanArray

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

2021Sep22

Morse code functions

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

2021Jun13

Navigate_IE

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

2021May31

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

Numeric Input Spinner

A nice Bootstrap 4 numeric spinner used on Input box Originally from

2020Sep17

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

1 2 ...6 ...11 12