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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ExcelVBA/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ExcelVBA/join
(Yahoo! ID required)

<*> To change settings via email:
ExcelVBA-digest@yahoogroups.com
ExcelVBA-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
ExcelVBA-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/