LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2004, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 29 Jun 2004 10:17:44 -0400
Reply-To:   "Lustig, Roger" <roger.lustig@CITIGROUP.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Lustig, Roger" <roger.lustig@CITIGROUP.COM>
Subject:   Re: What is the DDE command to force Excel open in R1C1 reference style?
Comments:   To: Vladimir Grechko <vlad.grechko@MAIL.RU>
Content-Type:   text/plain; charset="iso-8859-1"

Have you tried the function A1.R1C1(<logical>) ?

True for A1, false for R1C1.

Roger

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Vladimir Grechko Sent: Tuesday, June 29, 2004 9:42 AM To: SAS-L@LISTSERV.UGA.EDU Subject: What is the DDE command to force Excel open in R1C1 reference style?

Hello All,

I'm using DDE to open my Excel sessions, but I have not yet found a way to force Excel open in R1C1 refernce style. I have found a lot of references in Google on how _not_ to open Excel in this style, but none so far on how to make R1C1 the default. Can anybody help me out, please, with either the DDE command or changing the default in Excel?

Thanks in advance, Vlad

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu