BOLDCODES

Online library for developers by developers

Fresh 16 codes

Card image
ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any ...

Card image
ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. ...

Card image
VBInstr_Occurance

Returns location of text inside another with jump ability for ...

Card image
Match6_Until

Searches for six values in six columns and return the row number ...

Card image
FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending ...

Card image
CutString96_NumberBefore and After

Cuts the number found before our search word by going back ...

Card image
Match4_Until

Search 4 columns with a stop. Tell the function to stop ...

Card image
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Card image
VBInstr_Any

Returns the index where any of the words from AnStrSearchFor ...

Card image
ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Card image
VBInstr_Any

Search for string inside another, with ability to have multiple ...

Card image
ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another ...

Card image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to ...

Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on ...

Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a ...

Card image
RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). ...

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

394 / 1,219 = 32.32%

You code?

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

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
LastRow_Remove

Removes last row in a table starting certain cell. Creating and ...

Card image
Export2CSV

Exports a sheet into CSV file Dynamically finds number of ...

Card image
CutString96_NumberX

Extract a full number from string block having 1 or more full ...

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
CreateUniqueList

Create list of unique items from a column into another column ...

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
CountColumnCells_Unique

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

Card image
Match4_4thNot0

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

Boring stats Since Feb 18th, 2018

1,219
Codes
10
Private
394
Updated
1,021
Tested
198
Untested
18
Programmers
743
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

708

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