Getting content from multiple highlighted cells in Excel

Scripting Forums AppleScript | Mac OS X
,
#1

With an excel document open I would like to be able to highlight multiple cells and bring a list of the content into an applescript.

Currently when I highlight multiple cells I can only figure out how to get content from the first cell I highlight. I can’t figure out how to get the content from the other active cells. Can anyone help?

Thanks in advance.

Excel 2004, OS 10.4

#2

Hi,

I have Office X, but you can try the ‘value’ property of ‘range’:

tell application “Microsoft Excel”
set s to Selection
set v to Value of s
end tell

gl,