|Date: ||Fri, 5 Mar 2004 17:19:28 -0500|
|Reply-To: ||Howard Schreier <Howard_Schreier@ITA.DOC.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Howard Schreier <Howard_Schreier@ITA.DOC.GOV>|
|Subject: ||Re: MERGEing Excel cells via DDE|
I presume you mean via the Excel v.4 macro language, which is understood by
Excel when passed in using DDE.
I suspect that the feature allowing cells to be merged was introduced in
Excel after v.4 macro language went "legacy".
You can of course do it indirectly, by storing the VBA code you show in an
Excel macro module, then using DDE to launch the macro.
On Fri, 5 Mar 2004 16:46:27 -0500, Kevin Roland Viel <kviel@EMORY.EDU>
> I have searched macrofun.hlp for a function that will do merge cells.
>Might anyone suggest the equilavent to the following via DDE:
> With Selection
> .MergeCells = True
> End With
>Thanks in advance,
>Department of Epidemiology
>Rollins School of Public Health
>Atlanta, GA 30322