Search results 108

Sorted from new to old.

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

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

bs_grid

Bootstrap grid with php server-side example code (jQuery Datagrid plugin) From ...

2019Sep20

CopyRowHeight

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

2019Aug1

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Tel inputbox

Telephone number input box, using Bootstrap4, with list of countries and ...

2019Jun19

Excel 2010 hyperlink issue fix

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

2019Jun16

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

Yamm3 mega menu

A bootstrap mega menu Demo:

2019May12

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

1 2 ...5 6 7