Search results 221

Sorted from new to old.

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

MatchIf (aka VMatchIf)

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

2018Jun16

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

GetColumnName, ColumnName_XOffset

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

2018Jun15

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

ListBox_SelectedIndexes

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

2018Jun11

GenerateMemorablePassword

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

2018Jun11

FindName

Finds a name in a workbook, returns true or false

2018Jun10

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

2018Jun6

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31

CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22

1 2 ...13 14