ANmarAmdeen

Card image cap
SortArea3

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

Card image cap
SortArea1

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

Card image cap
Sort1Col

Sorts a column in Excel, easily, with options

Card image cap
strUnQuote

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

Card image cap
DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

Card image cap
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

Card image cap
GetTempFileName

Returns temp file name using FSO

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

Card image cap
XorC

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

Card image cap
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

Card image cap
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

Card image cap
DeleteAllFiles

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