Random codes

Codes Required

Similar codes

CellRead (SimpleLookup)

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

2018Jun25

ANmarAmdeen

Frm6 - ANmaMultiSelect

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

2021Jun23

ANmarAmdeen

Add2Column

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

2020Jan3

ANmarAmdeen

HMatchIf

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

2018Jun16

ANmarAmdeen

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

ANmarAmdeen

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

ANmarAmdeen

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

ANmarAmdeen

CreateList_Matching

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

2020May13

ANmarAmdeen

SortArea1

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

2018Jul4

ANmarAmdeen

Recently by developer

ANmaHTMLTables_Combine2

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

Thu 3PM

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

ANmarAmdeen

Password Validator

Javascript based password entry validator

2019Jan18

ANmarAmdeen

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

ANmarAmdeen

Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jun7

ANmarAmdeen