Re: Removing a row or column
Re: Removing a row or column
- Subject: Re: Removing a row or column
- From: Stan Cleveland <email@hidden>
- Date: Tue, 26 Mar 2013 16:27:02 -0700
On Mar 26, 2013, at 4:10 PM, Robert Cuilla wrote:
> Help to everyone,
>
> I would like to take an Excel file and select a complete column or row, such as "B" or "13" and delete using AS. Can anyone give me a little guidance to get started.
Hi Bob,
Try this:
tell application "Microsoft Excel"
delete selection
end tell
Or you can delete a specific range (in the currently active worksheet) without a selection like this:
tell application "Microsoft Excel"
delete (range "C:C")
delete (range "12:12")
end tell
HTH,
Stan C.
_______________________________________________
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