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

Card image cap
CopyRowHeight

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

Card image cap
MatchLastIf

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

Card image cap
IsThere_Remote

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
DirTree.xlsb

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

DirTree.zip

Card image cap
DialChart - Excel-VBA

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

DialChart.zip

Card image cap
Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

UnProtect.zip

Card image cap
Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

WebBrowser.zip

Card image cap
UnMergeFill

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

Card image cap
Select workbook (or workbook/worksheet) (Frm5)

Gives your user ability to select a workbook from list of open workbooks within ...

Frm5.zip

Card image cap
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

Card image cap
User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...