for without next

  1. T

    For without Next

    Hello, I have a custom tab from UI Editor. I keep getting 'For without Next' error and it highlights the End Sub. Have no idea why. Please help! Sub DC_Split(Optional ByVal Control As IRibbonControl) Application.Calculation = xlCalculationManual Application.EnableEvents = False...
    • temerson
    • Thread
    • activesheet.name allocation compile error for without next worksheet
    • Replies: 3
    • Forum: Excel Questions
  2. T

    VBA errors in Excel

    Hello, Below is my code. I have a workbook with 3 sheets "ALL RECORDS, ACTIVE, ARCHIVE", and I am trying to get the VBA to move the rows in the ALL RECORDS sheet that have "CURRENET" in Column J to the ACTIVE sheet, and rows that have "ARCHIVE" in Column J to the ARCHIVED sheet.......I am...
  3. J

    Moving active cell through columns, For without Next

    I am trying to get the activecell to move from its starting point and loop through columns selecting rows 1:6. I keep getting "For without Next". Here is what I have so far. Thanks for any help Sub Basic() Application.ScreenUpdating = False Dim source As Worksheet Dim destination As Worksheet...
  4. M

    VBA coding "For without next" error

    Hi people ! Could anyone kindly point me to where this nuisance error comes from ? I check practically every corner of the coding but just don't see how come there is any "for" or "next" absent. I also tried to solve the problem myself by looking up some online forums on similar questions, but...
  5. M

    VBA For Next without For in SQL script

    I'm not understanding why this script is not working. Basically I combined the two scripts and then created a user form with a few checkboxes......checkbox 1 do this, checkbox 2 do this. But now I am getting a Next without For error. I tried modifying it with the for i next but no help! Any...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top