Search results 463

Sorted from new to old.
Card image
Reversefile

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

Card image
GetColumnName, ColumnName_XOffset

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

Card image
ANStrRead + ANStrSave + ANStrSearch

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

Card image
ListBox_SelectedIndexes

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

Card image
FixPath, IsThere, IsThere1 ...

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

Card image
Col2Combo

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

Card image
1FileDB

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

Card image
Filter_GotoItem

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

Card image
Paragraph2Line + Line2Paragraph

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

Card image
CutRightString

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

Card image
ANStrColor2RGB + RGB2ANStrColor

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

Card image
getQueryString

Reading QueryString from JS

Card image
CutString3_Search

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

Card image
CutString

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

Card image
CutString3

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

Card image
CutString3

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