Search results 110

Sorted from new to old.

SheetName

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

2018Aug23

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

Base64encode + Base64decode

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

2018Jul31

Encrypt1 + Decrypt1

Encrypts (and decrypts) a string. To decrypt an encrypted string, use the ...

2018Jul25

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

2018Jul25

UnBreakAr + BreakAr

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

2018Jul25

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

2018Jul19

ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

2018Jul19

myURLDecode

Decode a URL, opposite of Server.URLEncode

2018Jul15

RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

2018Jul15

ViewSource

Display content of ASP file (any file for that matters) Using ...

2018Jul11

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

Capitalize

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

2018Jul3

XorC

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

2018Jul1

1 2 ...6 7