Re: So simple yet---I need help
Re: So simple yet---I need help
- Subject: Re: So simple yet---I need help
- From: Stan Cleveland <email@hidden>
- Date: Thu, 24 Apr 2008 13:05:22 -0700
- Thread-topic: So simple yet---I need help
On 4/24/08 12:33 PM, "Raymond P Reedy" wrote:
> Excel 11.4.1 and OS X 10.4.11
>
> I have a spreadsheet that may or may not have a number in column 2.
> If the cell is empty, I want to delete it an shift cells left. In
> debug and stepping thru it finds the empty cells but does not delete
> nor shift left.
>
> Here is my script...
>
> tell application "Microsoft Excel"
<snip>
> delete range range ("B" & i) shift left
<snip>
Ray, the correct syntax for shifting left is "shift shift to left". So use
the line below in place of the one in your code, above.
delete range range ("B" & i) shift shift to left
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