Search results 295

  2. Search results
  3. 1
Sorted from new to old.
Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16
Card image
Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16
Card image
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
WorkbookOpen_ANmar

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

2018Jun16
Card image
Crypt128

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

2018Jun14
Card image
OpenPassword + ClosePassword

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

2018Jun14
Card image
ANStrRead + ANStrSave + ANStrSearch

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

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

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

2018Jun11
Card image
1FileDB

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

2018Jun9
Card image
ComputerSN

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

2018Jun6
Card image
FindIn1DArray

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

2018Jun6
Card image
MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2
Card image
Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2
Card image
Paragraph2Line + Line2Paragraph

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

2018Jun2
Card image
Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2
12...171819