02-10-2015 01:52 PM
I have some cells that I need to merge in an Excel worksheet via DDE. All I've seen so far is to use:
put '[alignment(7, false,3,0)]';
after selecting the cells I want to merge. This doesn't seem to merge the cells correctly as they are still all separate cells.
Can anyone provide some additional code that would be the equivilent of the "Merge and Center" toolbar command in Excel?
08-21-2015 01:31 PM
If you have the dde reference connect to the excel system, the alignment statement will center and merge:
filename dde_sys dde 'excel|system';
file dde_sys ;
filename dde_sys clear;