Re: Excel
Re: Excel
- Subject: Re: Excel
- From: Thomas Maffucci <email@hidden>
- Date: Mon, 09 Feb 2009 13:03:26 -0500
- Thread-topic: Excel
>> T2:U6 is a range of cells. The first cell is on "T2", the last in
>> "U6".
>> This means the range t2,t3,t4,t5,t6, u2,u3,u4,u5,u6. A bicolumnar
>> range with 10 cells.
>>
>> U2:U6 is a columnar reference to these five cells range.
This will give you the formula you want under Excel 2008 without the
bothersome quote marks.
But the Lookup Formula syntax is not correct under Excel 2008.
--set AC84 to (ASCII character (84))
--set AC85 to (ASCII character (85))
set frw to 2
set lrw to 6
set Fclm to "T"
set Lclm to "U"
--set part1 to "(RC[-1]," & (AC84 & "2:" & AC85 & "6") & "," & (AC85 & "2:"
& AC85 & "6)")
set part1 to "=Lookup" & "(R3," & Fclm & frw & ":" & Lclm & lrw & "," & Lclm
& frw & ":" & Lclm & lrw & ")"
--set part1 to "(R3," & (AC84 & "2:" & AC85 & "6") & "," & (AC85 & "2:" &
AC85 & "6)")
--set part1 to (part1 as string)
--return (part1)
tell application "Microsoft Excel" to set value of cell "S3" to part1
--->=Lookup(R3,T2:U6,U2:U6)
_______________________________________________
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