Random codes

Codes Required

Similar codes

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

ANmarAmdeen

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

ANmarAmdeen

Match2

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

2018Jun16

ANmarAmdeen

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

ANmarAmdeen

HMatchIf

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

2018Jun16

ANmarAmdeen

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

ANmarAmdeen

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27

ANmarAmdeen

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

Recently by developer

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Sun 1PM

ANmarAmdeen

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Sun 1PM

ANmarAmdeen

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

ANmarAmdeen

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

ANmarAmdeen

ANmaCellFormat

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

Apr18

ANmarAmdeen

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

ANmarAmdeen

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

ANmarAmdeen

ArrayRead + ArraySave

Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...

2018Apr15

ANmarAmdeen