Search results 706

Sorted from new to old.

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

WorkbookOpen_ANmar

Opens Workbook in the background with no flickering and with options of ... ...

2018Jun16

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

FindName

Finds a name in a workbook, returns true or false

2018Jun10

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

1 2 ...40 ...44 45