Search results 78

Sorted from new to old.

SumOf_3Filters

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

2021Jan29

EnvironList

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

2021Jan12

Generate_PowerPoint

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

2020Dec22

Save Excel range (or shape) to picture

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

2020Dec21

CountDuplicates

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

2020Oct31

Part of cells in Excel

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

2020Oct13

UI_2ValidationsUpdate

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

2020May27

Delete_Unwanted_Rows

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

2020Apr14

Excel sheet textbox

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

2020Feb22

CopyRowHeight

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

2019Aug1

Date range picker

Bootstrap date range picker From

2019Jul31

MatchLastIf

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

2019Jun12

DialChart - Excel-VBA

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

2019Apr27

UnMergeFill

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

2019Apr16

User-Defined Formatting

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

2019Jan9

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

1 2 3 4 5