Random codes

Similar codes

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ANmarAmdeen

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Aug28

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

ANmarAmdeen

DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23

ANmarAmdeen

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

Nov1

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

Export2CSV

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

2022May16

ANmarAmdeen

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

Aug21

ANmarAmdeen

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

ANmarAmdeen

Fancybox iframe

This is to demonstrate how to call a Fancybox from inside an iframe into parent ...

2019Jan15

ANmarAmdeen

Match3

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

2018Jun16

ANmarAmdeen