Random codes

Random 24 Codes by our developers.

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Windows-like drop down menu

Classic-Windows-like dropdown menu using CSS and JS, library in zip is build in ...

2020Aug20

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

LogSheet_Add + LogSheet_Clear

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

2018Jun24

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

ASPjson

Read and write json data in and from Classic ASP From

2020Feb3

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

Feb9

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

Simple Captcha

Sometimes the simplest methods is the most powerful. That is what I said

2018Dec27

Crypt128

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

2018Jun14

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Path (ASP Classic)

Site physical actual location

2019Jul2

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

CSS Flowchart

A simple CSS flow chart with links

2019Jan11