Random codes

Similar codes

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

ANmarAmdeen

ANStr2Range

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

2022Nov11

ANmarAmdeen

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

ANmarAmdeen

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

ANmarAmdeen

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

ANmarAmdeen

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

ANmarAmdeen

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

ANmarAmdeen

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ANmarAmdeen

CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

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

May1

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

MatchIf2Up

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

Apr29

ANmarAmdeen

Modal form open Workbook

Do not open workbook from userform after .show

Aug3

ANmarAmdeen

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

ANmarAmdeen

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

ANmarAmdeen

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

ANmarAmdeen