Search results 93

  2. Search results
  3. functions
Sorted from new to old.
Card image
User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1
Card image
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1
Card image
Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9
Card image
Prevent Submit until reCaptcha

Disable Submit button until Google reCaptcha is verified, used reCaptcha v2.0 ...

2018Dec20
Card image
Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1
Card image
IsValidUTF8 + DecodeUTF8 + EncodeUTF8

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

2018Sep5
Card image
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23
Card image
ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

2018Jul26
Card image
SimpleCalendar

HTML calendar, simple, ready for implementing and customizing

2018Jul26
Card image
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26
Card image
UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25
Card image
RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

2018Jul9
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
12...56