Hopefully someone can help me, because if not I will not be able to migrate
my current collection of Applescripts to work with either Excel 2004 or Excel
2008 (I've been using Excel X because it still works).

So, this seems so simple that it should be obvious, but it's not. I've tried
just about everything, and my colleagues and I cannot come to a solution. I
want to get the range (preferably in "A1" format) of the currently selected
cell. That's it. Whether it's a range object or text, it doesn't matter. I
need to have the range itself to be able to pass to other functions and use
elsewhere after it is asked for. I can't simply always refer to the
selection. In fact, many of my scripts work much faster when I don't always
select the cell I want to work with. Here's the code snippet:

tell application "Microsoft Excel"
set rangeA1 to range of selection
return rangeA1
end tell

I always end up with a "missing value". I realize it is possible to get the
row and column, but many of Excel's commands after Excel X don't like R1C1
format for ranges.

Any help is appreciated. Thanks!
-Richard

G'day Richard

Just finished night shift, so this may appear to be a dumb question...!

Does the Workbook you are attempting to access have more than 1 sheet, if
so, you need to specify the sheet name as the pointer for excel to go to..

Try this link:

Copy a range from closed workbook (Local, Network and on the internet)

http://www.rondebruin.nl/copy7.htm

If this doesn't help, goto Ron's main page

http://www.rondebruin.nl/tips.htm

You may find something that could point you in the right direction.

HTH
MArk.

Richard8A -

If you don't get assistance in microsoft.public.excel.programming, I suggest
you post in the very active microsoft.public.mac.office.excel newsgroup.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Richard8A" <(E-Mail Removed)> wrote in message
news:5BBCB8A1-9681-474E-836C-(E-Mail Removed)...
> Hopefully someone can help me, because if not I will not be able to
> migrate
> my current collection of Applescripts to work with either Excel 2004 or
> Excel
> 2008 (I've been using Excel X because it still works).
>
> So, this seems so simple that it should be obvious, but it's not. I've
> tried
> just about everything, and my colleagues and I cannot come to a solution.
> I
> want to get the range (preferably in "A1" format) of the currently
> selected
> cell. That's it. Whether it's a range object or text, it doesn't matter. I
> need to have the range itself to be able to pass to other functions and
> use
> elsewhere after it is asked for. I can't simply always refer to the
> selection. In fact, many of my scripts work much faster when I don't
> always
> select the cell I want to work with. Here's the code snippet:
>
> tell application "Microsoft Excel"
> set rangeA1 to range of selection
> return rangeA1
> end tell
>
> I always end up with a "missing value". I realize it is possible to get
> the
> row and column, but many of Excel's commands after Excel X don't like R1C1
> format for ranges.
>
> Any help is appreciated. Thanks!
> -Richard