Search results 82

  2. Search results
  3. functions
Sorted from new to old.
Card image
SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9
Card image
Capitalize

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

2018Jul3
Card image
XorC

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

2018Jul1
Card image
Page area and Page Setup functions (Unfinished)

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

2018Jun30
Card image
HTMLTag + HTMLPair

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

2018Jun30
Card image
Distance_Calc_fromString

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

2018Jun27
Card image
ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24
Card image
LogSheet_Add + LogSheet_Clear

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

2018Jun24
Card image
Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14
Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11
Card image
1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9
Card image
RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2
Card image
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23
Card image
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27
Card image
Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...

2018Apr25
Card image
Str2DB + Str2App + Str2HTML

Set of functions to clean and revise cleaning of string before saving into ...

2018Apr21
12...56