• 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: Retrieving a "Range" in Excel for storage in a Database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Retrieving a "Range" in Excel for storage in a Database


  • Subject: Re: Retrieving a "Range" in Excel for storage in a Database
  • From: "Mark J. Reed" <email@hidden>
  • Date: Wed, 8 Jul 2009 23:54:13 -0400

Cells often move around as you design or modify a spreadsheet.  Refs
in formulas are automatically updated - your script isn't. :)

On Wednesday, July 8, 2009, Paul Berkowitz <email@hidden> wrote:
> On 7/8/09 9:47 AM, "Stan Cleveland" <email@hidden> wrote:
>
>> One more tidbit--you can give the same cell or range more than one name, any
>> and all of which can be used to reference the data therein. Also, the name
>> property reflects the name function accessed in the GUI from the menu
>> command "Insert > Name > Define...".
>
> Just out of interest, why does anyone want to name a cell? If it always
> refers to a fixed cell, such as F243, what's hard about referring to it by
> address, as cell "F243"? There must be a reason, I guess, but I can't think
> what it might be. Easier to remember? You'd better remember it *exactly*
> then. I would find that easier to confuse than the address.
>
> --
> Paul Berkowitz
>
>
>  _______________________________________________
> 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
>

--
Mark J. Reed <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: Retrieving a "Range" in Excel for storage in a Database (From: Stan Cleveland <email@hidden>)
 >Re: Retrieving a "Range" in Excel for storage in a Database (From: Paul Berkowitz <email@hidden>)

  • Prev by Date: Re: Retrieving a "Range" in Excel for storage in a Database
  • Next by Date: Re: Retrieving a "Range" in Excel for storage in a Database
  • Previous by thread: Re: Retrieving a "Range" in Excel for storage in a Database
  • Next by thread: Re: Retrieving a "Range" in Excel for storage in a Database
  • Index(es):
    • Date
    • Thread