Excel: Append to Range
Excel: Append to Range
- Subject: Excel: Append to Range
- From: Christopher Stone <email@hidden>
- Date: Tue, 24 Mar 2015 22:32:51 -0500
I have the first bit of this:
tell application "Microsoft Excel" tell active sheet of active workbook set lastFilledCell to get end range "A1" direction toward the bottom set firstBlankCell to get offset lastFilledCell row offset 1 end tell end tell
--> range "[Test_01.xlsx]Sheet1!$A$9" of application "Microsoft Excel"
However I want to append a list of lists to the end of it and need something similar to this:
# set value of range ("A1:A" & (length of fileNameList)) to fileNameList
I don't find any way to extract the column:row address components of cell firstBlankCell, so I can construct my new range limits.
Hopefully I'm just missing something.
If someone can help me out I'll be grateful.
-- Best Regards, Chris
|
_______________________________________________
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