Re: AppleScript and Excel VBA returning different values for particular column
Re: AppleScript and Excel VBA returning different values for particular column
- Subject: Re: AppleScript and Excel VBA returning different values for particular column
- From: David Wignall <email@hidden>
- Date: Sat, 22 Mar 2003 11:11:33 +1200
on 22/3/2003 8:33 AM, Wesley Furgiuele at email@hidden wrote:
>
set wksA1 to Value of Range("A1") --> Name
>
set wksB1 to Value of Range("B1") --> CUSIP
>
set wksC1 to Value of Range("C1") --> 0
>
set wksD1 to Value of Range("D1") --> Sector
set wksC1 to Address of Range("C1") --> $A:$A
You're being bitten by R1C1 notation and AppleScript thinks you want column
1. Quite annoying, really. Try this
set wksC1 to Value of Range("R1C3") --> "Ticker"
--
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.