Search results 59

Sorted from new to old.
Card image
IsFolder

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

Card image
CellRead

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

Card image
HMatchIf

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

Card image
MatchIf (aka VMatchIf)

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

Card image
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

Card image
FindName

Finds a name in a workbook, returns true or false

Card image
MoveDown + MoveUp

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

Card image
RGB2Long

Converts Red, Green and Blue integers into RGB long value

Card image
ANStrColor2RGB + RGB2ANStrColor

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

Card image
MyDayName

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

Card image
MyMonthName

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