<HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=windows-1250"><META content="IncrediMail 1.0" name=GENERATOR><!--IncrdiXMLRemarkStart><IncrdiX-Info><X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID><X-FVER>3.0</X-FVER><X-CNT>;</X-CNT></IncrdiX-Info><IncrdiXMLRemarkEnd--></HEAD><BODY style="BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; FONT-FAMILY: Arial" bgColor=#ffffff background="" scroll=yes ORGYPOS="0" X-FVER="3.0"><TABLE id=INCREDIMAINTABLE cellSpacing=0 cellPadding=2 width="100%" border=0><TBODY><TR><TD id=INCREDITEXTREGION style="FONT-SIZE: 12pt; CURSOR: auto; FONT-FAMILY: Arial" width="100%"><DIV> <FONT face=Arial size=3><P>Can I (in VEE6.2) read of mouse position on screen?</P></FONT></DIV><DIV>Thanks. </DIV><DIV> </DIV><DIV> </DIV><DIV><FONT size=2>Ing. Peter Samuhel</FONT></DIV><DIV><FONT size=2>Slovensk metrologick stav</FONT></DIV><DIV><FONT size=2>centrum 240</FONT></DIV><DIV><FONT size=2>Karlovesk 63</FONT></DIV><DIV><FONT size=2>842 55 Bratislava 4</FONT></DIV><DIV><FONT size=2>Slovak Republic</FONT></DIV><DIV><FONT face="Arial CE" size=2>e-mail: <A href="mailto:samuhel@smu.gov.sk"><FONT face="Times New Roman" size=3>samuhel@smu.gov.sk</FONT></A></FONT></DIV><DIV><FONT face="Arial CE" size=2>tel.: +421 2 60294304</FONT> </DIV><DIV><FONT face="Arial CE" size=2>fax: +421 2 65429592<BR>URL: </FONT><A title=http://www.smu.gov.sk/ href="http://www.smu.gov.sk/" target=_blank><FONT face="Arial CE" size=2>http://www.smu.gov.sk</FONT></A></DIV></TD></TR><TR><TD id=INCREDIFOOTER width="100%"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD width="100%"></TD><TD id=INCREDISOUND vAlign=bottom align=middle></TD><TD id=INCREDIANIM vAlign=bottom align=middle></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></BODY></HTML>
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!