Search results 203

Sorted from new to old.

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

2018Jul5

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

TextPercentageMatch

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

2018Jun26

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

HaveNonEnglish + StringASCIIs

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

2018Jun17

MatchIf_ThenDelete

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

2018Jun17

Match4

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

2018Jun16

MatchIf (aka VMatchIf)

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

2018Jun16

Col2Combo

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

2018Jun10

FindName

Finds a name in a workbook, returns true or false

2018Jun10

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

FindSheet

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

2018Jun7

1 2 ...12 13