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]
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