I am using a DDE link to EXCEL via a 4 GL to send data to an excel spreadsheet. The spreadsheet contains merged cells. When I attempt to send a data item from the 4 GL to an EXCEL cell within the merged pair, I receive the following EXCEL error message 'Cannot change data in a merged cell'. How do I reference a merged cell in EXCEL i.e R7C10/11 is a reference to the merged cells R7C10 and R7C11? How can I send data to merged cells?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Merged cells
- Thread starter Amie
- Start date
