Re: Getting from Cell to Cell in excel
Re: Getting from Cell to Cell in excel
- Subject: Re: Getting from Cell to Cell in excel
- From: Walter Ian Kaye <email@hidden>
- Date: Fri, 23 Jul 2004 12:46:53 -0700
Oops, correction:
tell app "Microsoft Excel"
set bCell to Cell 1 of UsedRange of Worksheet 1
set eCell to Cell -1 of UsedRange of Worksheet 1
set {bRow, eRow} to {Row of bCell, Row of eCell}
set {bCol, eCol} to {Column of bCell, Column of eCell}
repeat with iRow from bRow to eRow
repeat with iCol from bCol to eCol
set curCell to Range ("R" & iRow & "C" & iCol)
if Name of Font of curCell is "ConduitArdoise-Medium" then
set Name of Font of curCell to "Conduit ITC Medium"
else if Name of Font of curCell is "ConduitArdoise-Bold" then
set Name of Font of curCell to "Conduit ITC bold"
else if Name of Font of curCell is "ConduitArdoise" then
set Name of Font of curCell to "Conduit ITC"
else if Name of Font of curCell is "ConduitArdoise-Italic" then
set Name of Font of curCell to "Conduit ITC italic"
else
-- we ignore any unspecified fonts
end if
end repeat
end repeat
end tell
beep
(forgot to change Selection to curCell)
-boo
_______________________________________________
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.