Forum Discussion
Solved
Excel Loop problems
I have a data base that starts at cell AA2(Numbers), my macro works on columns to right of this and copies the result to a report, it then refreshes line AA2. I am using "Do ....Loop Until AA2<1" but...
- there will be a button to accept an answer as "Official Answer" or "Best Solution"
just click on that
WorkTests44 I see problem is in last line.
You need to clarify AA2 of which sheet?
Update it as below, in below line change "Course" with correct worksheet name where your cell AA2 is located.
Loop Until Sheets("Course").Range("AA2").Value < 1
Many Thanks, great help
- Glad to help..
Can pls accept it as a 'Solution' so that we can close this thread.Yes, great, how do I remove a thread?
- there will be a button to accept an answer as "Official Answer" or "Best Solution"
just click on that