Search results 240

  2. Search results
  3. art
Sorted from new to old.
Card image
Match2

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

2018Jun16
Card image
HMatchIf

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

2018Jun16
Card image
MatchIf (aka VMatchIf)

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

2018Jun16
Card image
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16
Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15
Card image
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14
Card image
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11
Card image
Col2Combo

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

2018Jun10
Card image
CutRightString

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

2018Jun2
Card image
CutLeft

Cuts the left part respecting words, without cutting words

2018May30
Card image
CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29
Card image
CountColumnCells + CountColumnCells_Criteria

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

2018May23
Card image
ANmaHTMLTemplate

Index.html template having headers with Bootstrap v4.1 and Font-Awesome (BS4.1 ...

2018May22
Card image
List of options (Frm87)

Show list of items with their description from "Settings" sheet Have that list ...

2018May17
Card image
InsertHyperlinks + GetHref

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

2018May13
Card image
Site Administration

This is an application to administer a website remotely through an ASP

2018Apr15
12...1415