Search results 61

Card image cap
CanAccessVBA

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

Card image cap
HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image cap
MatchIf (aka VMatchIf)

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

Card image cap
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Card image cap
FindName

Finds a name in a workbook, returns true or false

Card image cap
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Card image cap
FindIn1DArray

Returns 1 if an item found in array, 0 if not

Card image cap
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

Card image cap
ReplaceChars

Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...

Card image cap
FilesIn + FilesIn_Count

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

Card image cap
IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped