Help with OFFSET named ranges causing problems w/ DDE merge

derekpegg

Board Regular
Joined
Oct 7, 2005
Messages
145
I have a workbook template which I have added to recently. This is used to mail merge data into Word. After I had added to the template, I could no longer establish a DDE connection to Word to mail merge. To cut a (very) long story short, I have narrowed this error down to 12 OFFSET named ranges which I have recently added. When I remove these, the mail merge works fine, but I need them to create two charts I have also added.

Has anyone else come across this and does anyone know a way around this problem. Thanks in advance for any help as I have no more ideas to try to rectify this now.
 

Forum statistics

Threads
1,077,782
Messages
5,336,294
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top