Similar codes

Card image cap
FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

Card image cap
RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

Card image cap
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

Card image cap
FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Card image cap
Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

Card image cap
BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

Oct25

Card image cap
CanAccessVBA

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

2018Jun22

Card image cap
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my tools, very ...

2018Apr21

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

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

Apr30

Card image cap
MatchIf2Up

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

Apr29

Random Codes

Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Aug10

Card image cap
Embed fonts in Word doc

Embed fonts used in document, to make it available on any machine

2019Jan7

Card image cap
RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

2018Sep5

Card image cap
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7