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

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

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

Card image cap

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

Card image cap
Copy formulas

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

Card image cap

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

Card image cap

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

Card image cap

Checks if a file can be reached online or no Same as

Card image cap
TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

Card image cap

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


Card image cap
DialChart - Excel-VBA

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


Card image cap
Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code


Card image cap
Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform


Card image cap

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