BOLDCODES

Online bold library for bold coders by bald coders

Fresh 16 codes

Card image
Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the ...

Card image
SettingRead_Bulk

Reads list of passed SettingNames with defined separator from ...

Card image
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column ...

Card image
Match4_4thNot0

Searches for three cells in three columns then checks for 4th ...

Card image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: ...

Card image
JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to ...

Card image
GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son ...

Card image
HTMLTable_NoOfColumns

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

Card image
MaxOfArray

Gets the maximum number from an array. Like

Card image
CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. ...

Card image
HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string ...

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, ...

Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to ...

Card image
Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used ...

Card image
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside ...

Card image
ANmAddressSame

Checks if passed addresses are referring to same cell regardless ...

Boldfresh indicator

How fresh is code in this website? A calculation of total number of codes with version higher than 1 divided by total codes. An indicator showing how serious we are about the "Developing" aspect of writing code.

Bar Chart

385 / 1,200 = 32.08%

You code?

Join our growing community of programmers.
Add your dev work here, just login into your Linkedin account and accept BoldCodes.com!!

We log you in with your Linkedin, we save no passwords, no new password to remember, no new login, first time you in, we just save your name and ID issued to you by Linkedin.

Linkedin Login

Code share made easy

Programming functions and subroutines (or snippets, codes, etc.) that each can be downloaded separately or combined as a module.

This website is result of my efforts in categorizing and organizing my library of programming codes during my work years. A practice I managed to maintain since 1997, it helped me a lot in advancing in creating customizable and upgradable tools quickly and easily.

Programs website (Programs.ws) Sister website

When you code for a long time like me, you use tools, lots of them, and knowing myself, I have to keep them in a list. This is the list Programs.ws.

These tools are either webtools, applications in Windows or Android systems.

Featured Codes
Card image
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These ...

Card image
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and ...

Card image
GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function ...

Card image
iframeBtn

A button in iframe, to run certain command and return status to ...

Card image
Fill down

Fill down series in Excel. NotReadyYet! This is a ...

Card image
A is for Alpha

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

Card image
Special chars

How to type special characters in keyboard using ALT + keypad ...

Card image
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for ...

Card image
FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert ...

Card image
CountDuplicates

Counts how many duplicates found in a range of Excel cells. ...

Recently updated
Card image
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. ...

Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current ...

Card image
BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with ...

Card image
MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just ...

Card image
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells ...

Card image
ANmAddressSame

Checks if passed addresses are referring to same cell regardless ...

Card image
FixURL

Return safe URL after converting critical chars to whatever ...

Card image
Frequency

Checks how many items in an ANStr ANStr is list of items ...

Boring stats Since Feb 18th, 2018

1,200
Codes
10
Private
385
Updated
1,003
Tested
197
Untested
18
Programmers
724
Original
476
Imported
262.9k
Views
91.5k
Downloads
18
Programming languages
14
Categories

Excel functions (XLFxs.com) Sister website

XLFxs.com have Excel formulas, function combinations and other tricks and tips in Microsoft Excel to achieve several tasks and make life easier!

If codes here are little bit overwhelming, you can use Excel functions (and some other tricks) to do certain tricks to some level!

Our Programmers Top 3 programmers

689

ANmarAmdeen

26

JeffSmith

4

DevinGarlit

Top 5 Categories

Components

Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

UI

User interface, user controls, and display codes

Texts + Strings

Texts, strings, convert, replace, encode, parts and concatenations

File System

File structure, folder, FTPs, local, intranet and a like

Sessions

Codes for sessions and temporary memory managements.

All Categories

Top 5 Languages

VBA-Excel

Visual basic for applications that works only in Microsoft Excel, aka macros

ASP Classic

Active Server Pages for web development. Code here can also be used in VBA, VBA-Excel or VB6

JS+JQuery

Java script, JQuery that enhances web apps

VBA

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

HTML+CSS

HTML scripts along with CSS styles

All Languages