MyDev

Search results 59

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

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

2018Jun16

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

Finds a name in a workbook, returns true or false

2018Jun10

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2

Converts Red, Green and Blue integers into RGB long value

2018Jun2

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30

Returns the day name in several formats It uses either full date or only ...

2018Apr21

Returns the month name in one of 5 formats (below) It can use full date or ...

2018Apr21