Big bug in Excel Applescript?
Big bug in Excel Applescript?
- Subject: Big bug in Excel Applescript?
- From: Christian Prinoth <email@hidden>
- Date: Sun, 7 Mar 2010 22:08:51 +0100
Hi,
could you please try the following applescript on your Excel 2008 for Mac?
tell application "Microsoft Excel"
select range "A1:C3"
get address of rows of selection
select range "B1:D3"
get address of rows of selection
end tell
I get the following result:
tell application "Microsoft Excel"
select range "A1:C3"
get address every row of selection
--> {"$A$1:$C$1", "$A$2:$C$2", "$A$3:$C$3"}
select range "B1:D3"
get address every row of selection
--> {"$C$1:$E$1", "$C$2:$E$2", "$C$3:$E$3"}
Basically, the rows() class screws up if the range object it refers to does not start in the first column.
Thanks
Chris
_______________________________________________
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