Re: Extend a Formula in Excel
Re: Extend a Formula in Excel
- Subject: Re: Extend a Formula in Excel
- From: Paul Berkowitz <email@hidden>
- Date: Fri, 11 Apr 2008 08:46:49 -0700
- Thread-topic: Extend a Formula in Excel
Title: Re: Extend a Formula in Excel
On 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
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
_______________________________________________
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