for next loop error

Hi, new to this forum, hope you guys can help me with my issue altho my expressions are terrible :') I have attached a picture of how my excel looks like and my code below. Basically what it's supposed to do is to extract files from different locations and combine them as separate worksheets in...

I'm trying to use a "nested For Next loop" for the first time. I would appreciate your help for the following problem. Below is my code. I apologize for its length but, I thought it might be needed in its entirety to understand the issue. I'm getting a Compile Error - Next without For...

Hi group, I'm having some problems with a For/Next loop that has a "UnMerge" inside it. After the copy and paste is completed, the routine stops and doesn't complete the "Next" portion of the loop. Are they any thoughts as to why? What should I do to fix this? Here is the code I'm using...

Hi there, When I run this code I get the compile error "next without for" and I can't figure out why Sub Find_Class_A1_then_Hide() Application.ScreenUpdating = False Dim r, Lastrow, cLastrow, tRow As Long Lastrow = Cells(Rows.Count, "A").End(xlUp).Row For r = 1 To Lastrow cLastrow = Cells(r...

Hello - in the following code it is suppose to take the values in column B on activesheet one at a time and perform a search of that value on sheet (SMs), returning it and the values of neighboring cells back to active sheet. I can not get it to work as is...right now I am getting the "next...

I'm working to finish up my final project for a financial modeling class. Below is the code for a section. I haven't made many changes lately, but all of a sudden, every time I go to run it, I'm getting an error saying that the next to last "Next" does not have a "For". I've gone over it so many...

Hi guys, I want to create a macro that will loop through a range and clear a row if the value in the coulm A matches a value in another sheet. Then I want the macro to pick another value from another sheet and do the loop again. And again and again through the same rows but changing the checked...