Hi Tony
That would be best and would really help people understand what is going on.
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of Tony Davis
Sent: Wednesday, 28 September 2011 7:33 PM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Macro to run until dates match
Hi Paul,
What is the protocol here, should I copy/paste the macro to an email,as I
see that attachments are frowned upon?
Tony
On 27 September 2011 13:16, Paul Schreiner <schreiner_paul@att.net> wrote:
> **
>
>
> I'm not sure if the terms you're using match the definitions that I
> have for the same terms!
>
> If you're running an actual macro, then you can always create a loop
> (while, or
> for..)
> and test a value against the value in a cell.
>
> If you can show us what your macro looks like, perhaps we can suggest
> changes to create the loop.
>
> Paul
> -----------------------------------------
> "Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can." - John Wesley
> -----------------------------------------
>
> ________________________________
> From: Tony <studiot@gmail.com>
> To: ExcelVBA@yahoogroups.com
> Sent: Tue, September 27, 2011 6:36:59 AM
> Subject: [ExcelVBA] Macro to run until dates match
>
>
>
> Not sure if what I am asking is possible, but I have a workbook with
> macros that rotate staff against duties and advance the week ending
> date. ( simply done; C1 contains weekending date, D1=C1+7, so I copy
> and paste special values, the staff are rotated by cut and insert cut
> cells)
>
> with this I run the macro which will advance 1 week at a time, until I
> reach the desired week ending date. What I was wondering was if it
> would be possible to write a macro that would advance until a date
> entered in another cell was matched? E.G. I enter 25/12/11 in a
> designated cell and execute the macro which will run until C1 contains
> the same date.
>
> Regards
>
> Tony
>
> [Non-text portions of this message have been removed]
>
>
>
--
Save paper - do you really need to print this email?
Save electricity - do you really need to send this email?
Save your own energy - do you really need to read this email?
[Non-text portions of this message have been removed]
------------------------------------
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------Yahoo! Groups Links
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar