Excel 2004 Scripting Block
Excel 2004 Scripting Block
- Subject: Excel 2004 Scripting Block
- From: Jason Bourque <email@hidden>
- Date: Thu, 28 Oct 2004 09:11:26 -0400
Title: Excel 2004 Scripting Block
Hello,
I am trying to find a row that has a value in column D
The script runs but does nothing sometimes other it return a value of “”
This is some of the things I tried. Is there any reference on script 2004?
set vValueToFind to "6001-014"
tell application "Microsoft Excel"
tell sheet 1 of document 1
set vNth to 3
return selection
repeat
-- a reference to (first row whose value of cell "D" is "6001-014")
set vCellLoc to ("R" & 10 & "C1") as string
return value of cell vCellLoc
if (value of cell "D" of row vNth) is equal to vValueToFind then
return value of cell "A" of row vNth
exit repeat
end if
if value of cell "A" of row vNth is "" then exit repeat
set vNth to 1 + 1
end repeat
end tell
end tell
Thanks,
Jason Bourque
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden