I finally got it to work by going back to the "ActiveCell " at the end of the Macro as well as at the start. Maybe there is a better way, but it worked for me.
Thanks to all you who offered suggestions.
Stringsam
Last Activity: Aug 13 '06, 01:27 AM
Joined: Aug 6 '06
Location:
-
Thank you BSOB.
I have tried creating a simple exercise to test the Loop. The loop should stop when the cell value reaches zero. When I run the Macro, the steps work, but the "do until" does not recognize the "zero" when it is actually computed. Therefore, I have to shut the operation down. Amazingly though, if I hardcode the zero, the loop stops as desired. The "test" code follows. Maybe someone...Leave a comment:
-
Thank you sashi for the code!Leave a comment:
-
I found similar code in a book yesterday, but I have failed at the posting. What I am trying to do is to have the Macro stop when the value in a cell reaches zero. That is, there is no one left to assign a dining spot to. I think I need to know how to reference the cell value, if it possible to do so from the Macro. Here is what I have tried, and got a syntax error message.
Sub Macro1_test_DoL oop()
'
' Macro1 Macro...Leave a comment:
-
Help! How to do a basic loop in VB?
I have worked extensively with Pivot Tables, etc in Excel (97version). But, the closest I have gotten to VB is using the "record" feature.
I now have a neat little Macro that performs several steps. But I need to be able to loop it until all the "assignment s" have been completed. I presume there is some simple feature to call up the Macro that I now have, and execute it until all the assignments have been made,...
No activity results to display
Leave a comment: