Browse codes

VBA-Excel 133 Visual basic for applications that works only in Microsoft Excel, aka macros

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

Wed May27 10AM

Creates list of items found in rows, where these rows match a value in another ...

Wed May13 10AM

Creates list of unique items found in a column, returns string with items ...

Wed May6 9AM

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

Mon Apr20 9AM

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

Tue Apr14 6AM

Deletes all sheets in a workbook keeping only one

Fri Apr3 11AM

Checks if a workbook is found in a SharePoint location or not, giving a full ...

Wed Apr1 10AM

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

Tue Mar31 11AM

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

Tue Mar24 8AM

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

Sat Mar21 4PM

VBA-Excel function to connect to SQL Database server, in addition to ...

Fri Mar20 7AM

Remove any char (or string) found between two quotes in a string This is an ...

Mon Mar9 6PM