Extend a Formula in Excel
Extend a Formula in Excel
- Subject: Extend a Formula in Excel
- From: Steven Valenti <email@hidden>
- Date: Fri, 11 Apr 2008 11:07:31 -0400
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