I spend so much of my time looking at the emails DISTRIBUTED, that I don't
usually go to the site itself.
If the macro is LARGE, then it might be easier to summarize it.
("large" is a relative term... to me, 500 lines isn't large.)
I'd start with posting the macro, and perhaps some sample data.
If it's too cumbersome to work with, one of us may ask for you to send a file
directly.
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 Davis <studiot@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Wed, September 28, 2011 5:33:12 AM
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
[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
----------------------------------
Tidak ada komentar:
Posting Komentar