VBA-Excel 354

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

Sorted from new to old.

CopyRowHeight

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

2019Aug1

MatchLastIf

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

2019Jun12

IsThere_Remote

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

2019Jun7

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

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

2019Jun2

DirTree.xlsb

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

2019May20

DialChart - Excel-VBA

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

2019Apr27

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

UnMergeFill

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

2019Apr16

Frm9 - Select workbook (or workbook/worksheet)

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

2019Apr3

SheetAdd_ANmar

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

2019Apr1

User-defined type error

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

2019Feb1

MinIF and MaxIF in Excel 2010

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

2019Feb1

User-Defined Formatting

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

2019Jan9

Open different Filestypes

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

2019Jan9

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

1 2 ...16 ...22 23