Search results 480

  2. Search results
  3. From
Sorted from new to old.
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
Reversefile

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

2018Jun16
Card image
GetColumnName, ColumnName_XOffset

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

2018Jun15
Card image
ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14
Card image
ListBox_SelectedIndexes

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

2018Jun11
Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11
Card image
Col2Combo

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

2018Jun10
Card image
1FileDB

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

2018Jun9
Card image
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7
Card image
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2
Card image
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2
Card image
ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30
Card image
getQueryString

Reading QueryString from JS

2018May29
Card image
CutString3_Search

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

2018May29
Card image
CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29
Card image
CutString3

Cuts string from a larger one based on a specific separator.

2018May29
12...2930