Re: Extend a Formula in Excel
Re: Extend a Formula in Excel
- Subject: Re: Extend a Formula in Excel
- From: Steven Valenti <email@hidden>
- Date: Fri, 11 Apr 2008 15:40:10 -0400
That's what I been looking for...Thank you!!!
Steven Valenti
Macintosh Support Specialist
Zippo Mfg. Co.
33 Barbour Street
Bradford, PA 16701
Check 'fill down' in the Table Suite. If that's the correct formula then this should work (untested):
tell application "Microsoft Excel"
set EndRow to first row index of last row of used range of active sheet
--Color Charge
set formula of cell "K15" of sheet "ALL PRINTS" of active workbook to ¬
"=E15*C2"
fill down range ("K15:K" & EndRow)
end tell
--
Paul Berkowitz
Title: Re: Extend a Formula in ExcelOn 4/11/08 8:07 AM, "Steven Valenti" <email@hidden> wrote:
Using Excel 2004, I want to extend a formula down my column but can't seem to figure out how to do this or what this is even called. Anyone have an idea? I currently have AppleScript making the same formula in every row and takes a long time.
Thanks
tell application "Microsoft Excel"
set EndRow to first row index of last row of used range of active sheet
repeat with ThisRow from 15 to EndRow
--Color Charge
set formula of cell ("K" & ThisRow) of sheet "ALL PRINTS" of active workbook to ¬
"=E" & ThisRow & "*$C$2"
end repeat
end tell
_______________________________________________
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