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

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

Card image cap
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

Card image cap
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

Card image cap
Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

Card image cap
Run macro

Runs a macro from another workbook (Workbook has to be open).

Card image cap
Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

Card image cap
Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

Card image cap
Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

Card image cap
TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip