SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

Date range picker

Bootstrap date range picker From

ng-bs-daterangepicker-master.zip

MatchLastIf

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