Re: Get all the ranges of a Excel spreadsheet
Re: Get all the ranges of a Excel spreadsheet
- Subject: Re: Get all the ranges of a Excel spreadsheet
- From: David Wignall <email@hidden>
- Date: Fri, 18 Apr 2003 11:11:31 +1200
on 18/4/2003 8:11 AM, Sam Griffith at email@hidden wrote:
>
Does anyone know how to write a script to get all the named ranges on a
>
sheet in Excel X?
Names are a collection, ordered by alphabetic ascending for Names at the
workbook level. Thus
repeat with i from 1 to (count of Names)
display dialog (Name of Name (i) & " " & Value of Name (i))
end repeat
Unfortunately I can't see any way to find only the names for a particular
sheet, other than parsing the text returned for the Value or the RefersTo
properties.
If the Names are at the sheet level then they appear in the collection
before the workbook level Names. Again, I can find no way of restricting the
scope to any one sheet.
--
Dave
"Perhaps the truth is less interesting than the facts?"
Amy Weiss,
The RIAA's Senior Vice President of Communications
Email to The Register
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.