Search results 1,004

Sorted from new to old.

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Page area and Page Setup functions (Unfinished)

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

2018Jun30

SharePointURL2Path + Path2SharePointURL

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

2018Jun30

DeleteAllFiles

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

2018Jun30

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

WordsOf + Words_Len

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

2018Jun28

Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

UTF8R_toChar

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

2018Jun26

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

WeekNum

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

2018Jun26

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

1 2 ...56 ...62 63