Codes Required

Similar codes

Card image cap
CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Card image cap
Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Card image cap
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Card image cap
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

Card image cap
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

Card image cap
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

Card image cap
Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

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
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

Nov29

Card image cap
Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

Aug8

Card image cap
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

Card image cap
ChrW

Insert special characters inside Cell, using ChrW

2018Sep19