Search results 59

Sorted from new to old.
Card image
CellRead

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

Card image
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Card image
Match3

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

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
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

Card image
RGB2Long

Converts Red, Green and Blue integers into RGB long value

Card image
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

Card image
ANStrColor2RGB + RGB2ANStrColor

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

Card image
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...