AnsweredAssumed Answered

vrf AW: Excel ActiveX question

Question asked by bernhardt on Jan 15, 2004
Hi Tom,

use the following commands:
set range = sheet.Range("A2:D2");
Range.Merge();
Range.HorizontalAlignment = xlCenter;
Range.ColumnWidth = 10;

Best regards
M. Bernhardt
---------------------------------------------
SOMATEC - Software fr Maschinensteuerungen
und Automatisierungstechnik GbR

Jagdweg 7a
D-82041 Deisenhofen

Telefon :  (089) 613 984 94
Fax :      (089) 613 981 23
Email :    Bernhardt@somatec.de
homepage : www.somatec.com
---------------------------------------------


-----Ursprngliche Nachricht-----
Von:      Thomas.Mitchell@Autoliv.com [mailto:Thomas.Mitchell@Autoliv.com]
Gesendet:     Donnerstag, 15. Januar 2004 17:10
An:     VRF
Betreff:     [vrf] Excel ActiveX  question

I'm in the process of converting an older program that used DDE to
communicate with Excel to ActiveX.  I am making good progress except for
one area.  In my DDE program, I write some text to a cell, then merge the
cell with cells in the same row combining columns, then centering the text.
I know that there is a way to do this, plus adjust the width of each cell.
Anyone have any examples on how to do this?  I had one at one time, but
some how lost it when I received my new PC, and the all of the old files
didn't get transferred over.

Thanks

Tom Mitchell
Autoliv
AEA



---
You are currently subscribed to vrf as: Bernhardt@somatec.de
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible
inclusion in VEE 7.0!

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!

Outcomes