Search results 295

Sorted from new to old.

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

FormulasFlatten

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

2018Jun30

RandomNumber

Generate random number between Lower and upper numbers provided

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

WeekNum

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

2018Jun26

CellRead (SimpleLookup)

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

2018Jun25

CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

1 2 ...16 ...18 19