DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

COUNTIFS as Rank

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

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2 VB.net pdf books

Free from apress website https://www.apress.com More books

programming-web-w-VB-.net-master.zip

Part of cells in Excel

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

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

CSS Card effect

CSS Card Hover animated effect From

css-card-hover-effects.zip