Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel Find an empty cell



Is this a question of some sort? What's your question? Do you need help? If
you'd take a bit of effort to frame a question coherently, you'd  make it
possible for people to offer some help. Or are you just trying to help _us_
by offering these "tidbits of code to work with"? I can't see how they'd be
much help to anyone, but you never know.

Did the last answer from this list help you in any way? You might want to
say so, if so. That could possibly form a start to the next step, if you in
fact need help with a next step.

What good is

    find of range "A:A" what ""

doing you? You're not doing anything with the result, at least nothing
you're telling us about. Is that connected with a problem? Why all the
mystery?

If you would explain exactly what you're trying to do, someone might be able
to help.

-- 
Paul Berkowitz


> From: Brandon Hunt <email@hidden>
> Date: Tue, 26 Sep 2006 00:02:28 -0500
> To: "email@hidden" <email@hidden>
> Conversation: Excel Find an empty cell
> Subject: Re: Re: Excel Find an empty cell
> 
> I worked on this and changed my method of finding the empty cell now I know
> the empty cell I need to fill this cell with the date and the cell next to
> it with the curent date here are two tidbits of code to work with
> 
> --To Find The Cell
> tell application "Microsoft Excel"
>     open workbook workbook file name "users:brandonhunt:documents:TIme
> Sheet.xls"
>     find of range "A:A" what ""
> end tell
> 
> 
> --To insert date and time into two cells respectivly
> tell application "Microsoft Excel"
>     open workbook workbook file name "users:brandonhunt:documents:TIme
> Sheet.xls"
>     set value of cell "a1" to (date string of (current date))
>     set value of cell "b2" to (time string of (current date))
> 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:
> http://lists.apple.com/mailman/options/applescript-users/email@hidden
> 
> This email sent to email@hidden
> 


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/applescript-users/email@hidden

This email sent to email@hidden

References: 
 >Re: Re: Excel Find an empty cell (From: Brandon Hunt <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.