Loop Execution--Questions

Hey guys,

Here is some background about me and this project I am working on. I am a college grad that just recieved his first position. My job is to go through this workbook that is broken from the database and begin rewriting some programming to make it automated again. I've reached my first stump, I hope you guys can help!


The spreadsheet consist of the previous year's last quarter, and the current year's 4 quarters. The macros will take whatever is in the last column (Previous year's last quarter), copy it, and paste it into the correct column. Next, it would clear everything else. There is 4 different worksheets that it will automate through. For some reason, I keep getting inconsistant results with this macros and I cannot figure it out.

Please Login or Register  to view this content.

Any ideas? questions?
Thanks!

Maybe using the macrorecorder will result in less code than you have now.
There's a lot of VBA basics (courses) on the Internet. Not indavisable to study those first.

In addition, can anyone help me with this code. I dont quite understand what it does...


First loop, endrow = nothing. Second loop endrow = "Title". Next, endrow = nothing thereafter.

Please Login or Register  to view this content.

Hello VBNewb,

Welcome to the Forum!

In response to your first question, please define what you mean by "inconsistent".

In response to the second question, the macro is performing a search loop using Find and FindNext. Find performs a one time search and is either successful or not. If it is successful then control is passed on to the Do ... Loop. Starting at the next cell after the last successful Find, FindNext will continue until either another instance is found or it returns back to the first find. The variable flg keeps track of the row where the first Find occurred.

Hello VBNewb,

This is the first Find. If successful it will return a reference to the cell where the value was found. The Set statement is used to assign an object to an object variable. In this case, the object variable is Endrow.

If the search is successful Endrow will either be a reference to the cell or set to the special object variable Nothing. The IF statement checks if Find was successful or not and if not then the macro terminates.