Search results 22

Sorted from new to old.

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

Steps Recorder Win10 app

Win10 application already found in Windows. to generate list of steps with ...

2024Feb16

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Card15-BS3

Cards in bootstrap 3 with hover effect

2019Mar29

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

SettingRead_JR

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

2018Jun26

CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

HaveNonEnglish + StringASCIIs

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

2018Jun17

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

Match4

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

2018Jun16

1 2