Join Merged

Location on ribbon: Tab DVD Addin → Group Cells and Rows

Command ID: btnGetCellMerge

What it does

The command scans the selection and collects the address of the top-left cell of every merged area (or single cell) that holds data, joins them into one string and writes it into a cell you pick. The output looks like F8+F10 — addresses, not cell contents.

Use it to build the configuration columns Batch print relies on — the filename cell, the driver cell, the ranges to auto-fit — without typing addresses by hand or miscounting cells on a form full of merges.

How to use

1. Select the area containing the merged cells you need addresses for (a generous selection is fine; the command works it out).
2. Click DVD Addin → Cells and Rows → Join Merged.
3. The prompt "Select cell to paste" appears — click the destination cell and press OK.
4. The address string is written there and the status bar reports "Joined 2 cell addresses into J2".
5. The separator comes from Preferences → Cells and Rows → Delimiter for Join Text; set Custom = + to get the F8+F10 form the other DVD Addin commands expect.

Example

An acceptance-record template has merged cell F8:H8 for "Section" and merged cell F10:H10 for "Location" — the two cells whose values change on every printed copy. Select F5:H15, click Join Merged and pick the destination in your configuration sheet. The result F8+F10 drops straight into the Batch print configuration column.

Notes

• The output is cell addresses, not content. Use Join Text when you want the values.
• A merge spanning several columns or rows yields a single address, its top-left cell (F8 for F8:H8), and each merged area appears only once no matter how widely you select.
• Cells with no data are skipped — put a temporary value in a blank cell if you need its address.
• Un-merged single cells that hold data are included as well.
• Addresses are relative and carry no sheet name; overwriting the destination cell cannot be undone with Ctrl+Z.

Related

• Join Text — joins cell values instead of addresses.
• Batch print — consumes this address string as its driver-cell / filename-cell configuration.
• Merge keep data — create and adjust the merged cells on the template.