Next Without For (Error)

[Leonardo1234]

Hi Guys

I tried to solve this end if without block if Issue but i was unable to solve it so plz help me in solving the same Sir
Below is the code
Thnx for ur Great Help

Please Login or Register  to view this content.

[CheeseSandwich]

The below part does not have a: Next bc6

Please Login or Register  to view this content.

[Leonardo1234]

Yes it has bc6
I am getting next without For Error Now Sir

[CheeseSandwich]

That is what is causing the error, you have a for without a next...

You can't have a for without a next or a next without a for.

[Leonardo1234]

So what should i do with this that i dont know Sir, So plz really really help me in solving this Sir

[CheeseSandwich]

Replace the removing rows part with the below:

Please Login or Register  to view this content.

[Leonardo1234]

Now i am getting block if without end if Sir

[CheeseSandwich]

Go through your code and make sure that every 'If' has an 'End If' and Every 'For' has a 'Next'

[Leonardo1234]

Np sir i will do this part
But i need one more help in solving Next without For error Sir plz

[Leonardo1234]

Please Login or Register  to view this content.

Sir plz help in solving here also Sir for Next without For

[bebo021999]

From the line of "Application.ScreenUpdating = False"
count down:
line 13 & 14 there are 2 "If" but one "End If"
line 25 & 26 there are 2 "If" but one "End If"
Next group of 2 If:

If wsh3.Range("C2").Value <> "" Or wsh3.Range("C2").Value = "" Then 
              If VBA.Asc(UCase(wsh3.Range("C2"))) < 64 And VBA.Asc(UCase(wsh3.Range("C2"))) > 91 Then  

have only one "end if"

[Leonardo1234]

Please Login or Register  to view this content.

Sir Now i putted the end if & check all if conditions but i am gettingf error block if without end if

[CheeseSandwich]

Was missing an End If on the last section, if you indent your code within the 'If' 'Else' as below it will be easier to spot as you go.

Please Login or Register  to view this content.

[Leonardo1234]

Thnx Both of u in helping me in solving this problem
It has been solved