Search results 517

Sorted from new to old.

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

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

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

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

NumberTextArabic

Adds Arabic unit to a number using proper Arabic grammar Units can be ...

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

2018Jun20

1 2 ...26 ...32 33