Search results 196

Sorted from new to old.
Card image
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image
strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

Card image
XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

Card image
DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

Card image
WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

Card image
UTF8R_toChar

Converts characters created by program R into actual chars as in < U+641 > to ...

Card image
WeekNum

Generates the calendar week number for a certain date, counting the first week ...

Card image
DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

Card image
AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

Card image
IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

Card image
Match2

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

Card image
BrowseWorkbook + BrowseWorkbook_Save

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

Card image
Convert2SQLDate

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

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 ...