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 ...

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

DialChart.zip

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...