Search results 64

  2. Search results
  3. matches
Sorted from new to old.
Card image
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14
Card image
HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30
Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26
Card image
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25
Card image
ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24
Card image
File_FirstFound

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

2018Jun20
Card image
HaveNonEnglish + StringASCIIs

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

2018Jun17
Card image
RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17
Card image
MatchIf_ThenDelete

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

2018Jun17
Card image
CellRead

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

2018Jun16
Card image
Match4

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

2018Jun16
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2
Card image
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23
Card image
InsertHyperlinks + GetHref

Converts https found in text into anchers < a > Comes with GetHref as bonus ...

2018May13
Card image
Read Write and Append Text

Uses FSO to read, write, or append text in a file

2018Apr15
1234