• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Excel 2011: Select noncontiguous columns
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel 2011: Select noncontiguous columns


  • Subject: Re: Excel 2011: Select noncontiguous columns
  • From: Paul Berkowitz <email@hidden>
  • Date: Thu, 20 Oct 2011 02:21:48 -0700
  • Thread-topic: Excel 2011: Select noncontiguous columns


--
Paul Berkowitz


> From: David Wignall <email@hidden>
> Date: Thu, 20 Oct 2011 22:15:07 +1300
> To: AppleScript-Users <email@hidden>
> Subject: Re: Excel 2011: Select noncontiguous columns
>
>
> On 20 Oct 2011, at 9:27 PM, Paul Berkowitz wrote:
>
>> On 10/20/11 12:25 AM, "Olivier Berquin" <email@hidden> wrote:
>>
>>>
>>> I really don¹t understand what is happening.
>>
>> It's a built-in limitation, but not a bug.
>>
>> You're supposed to be able to do almost exactly what you wanted, this way:
>>
>> tell application "Microsoft Excel"
>>    tell active sheet
>>        set myRange to union range1 column 6 range2 column 8 range3 column
>> 11 range4 column 11 range5 column 14 range6 column 17
>>    end tell
>>    myRange
>>    set bold of font object of myRange to true
>>    --set width of  myRange to 14 --?
>> end tell
>>
>>
>> It (the 'union' command does) works as far as creating and getting myRange,
>> and it will also set the font of the whole range to bold. That's because
>> myRange is a range, and a range can have a single font object, whose
>> properties, like bold, can be set. But a range does not have a 'column
>> width', only a total width, which makes no sense for a range of
>> non-contiguous columns. The same applies even if you refer to it as range
>> "F:F,H:H,K:K,N:N,Q:Q", as you found.
>
> Respectfully Paul, I must disagree. The script Oliver posted
>
>> tell application "Microsoft Excel"
>> tell active workbook
>> tell active sheet
>> set myRange to column ("F:G,I:J")
>> set column width of myRange to 5
>> end tell
>> end tell
>> end tell
>
> works perfectly well. What also works is
>
> tell application "Microsoft Excel"
> set rng to range ("F:F,H:H,J:J,L:L")
> set column width of rng to 14
> end tell
>
> (FWIW, conceptually it's identical to what you would write in VBA).
>
> A range object does have a column width. It is the width of each column that
> comprises the range. As the range object must have at least one cell you can
> in fact say
>
> tell application "Microsoft Excel"
> set rng to range ("A1")
> set column width of rng to 26
> end tell
>
> I sent Oliver my solution off list (unintentionally - that whole 'reply not to
> list' thing that happens here) yet for some reason they did not work for him.
> I have no idea why; these scripts I have tested with Excel 2011 and Excel 2008
> using both Smile and AppleScript Editor. The only time they error is if Excel
> 2011 is not open when the script runs, in which case XL reaches the Workbook
> Gallery and stops thus no workbook is open.
>
> --
> Dave _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> AppleScript-Users mailing list      (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> Archives: http://lists.apple.com/archives/applescript-users
>
> This email sent to email@hidden


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

References: 
 >Re: Excel 2011: Select noncontiguous columns (From: David Wignall <email@hidden>)

  • Prev by Date: Re: Excel 2011: Select noncontiguous columns
  • Next by Date: Re: Excel 2011: Select noncontiguous columns
  • Previous by thread: Re: Excel 2011: Select noncontiguous columns
  • Next by thread: Re: Excel 2011: Select noncontiguous columns
  • Index(es):
    • Date
    • Thread