Similar codes

Card image cap
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

Card image cap
CountDuplicates

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

2020Oct31

Card image cap
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Card image cap
IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

Card image cap
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Card image cap
ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

Card image cap
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Card image cap
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Tue 7AM

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

Card image cap
ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Card image cap
MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

Card image cap
Calendar, a pure-VBA userform (FrmCal)

VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...

2018May16