Search results 114

Sorted from new to old.

IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

2018Sep5

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

2018Jul31

Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29

DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

SplitTo2DArray

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

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

WordsOf + Words_Len

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

2018Jun28

ANBS controls

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

2018Jun24

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

1 2 ...6 7 8