Similar codes

Card image cap
CellRead (SimpleLookup)

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

2018Jun25

Card image cap
CreateList_Matching

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

2020May13

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

Card image cap
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

Card image cap
ANmaRemoveDuplicates

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

2022Sep25

Card image cap
CountColumnCells + CountColumnCells_Criteria

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

2018May23

Card image cap
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Card image cap
Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

Recently by developer

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 ...

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Random Codes

Card image cap
ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

2018Jul19

Card image cap
CanAccessVBA

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

2018Jun22

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

2018Jun11