Random codes

Random 24 Codes by our developers.
Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Card image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

Card image
Show/hide ribbon

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

Card image
DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

Card image
FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

Card image
Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

Card image
Star rating

Another Bootstrap rating system using Font-Awesome

Card image
gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

Card image
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image
Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

Card image
Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

Card image
ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

Card image
Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

Card image
RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

Card image
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Card image
HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

Card image
SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

Card image
ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Card image
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

Card image
Capitalize1st

Capitalize 1st letter of a string

Card image
Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

Card image
IsThere_Remote

Checks if a file can be reached online or no Same as

Card image
Hide SQL table

A simple easy way to hide tables in SQL Server

Card image
CSS Analog clock

Pure CSS Analog clock, found it in my archive