"invalid next control variable reference" While trying to compile.

**Juhl94** · 09-01-2022, 10:08 AM

I'm trying to make a Multiple Solver using VBA in excel to make my work go faster.
I cant seem to figure out what i'm doing wrong even tho this should be super simple. (relative new to VBA and Excel)
I think the error has something to do with my "For i" and my "Next i"=?
Hope someone can hlep me out!

PHP Code:


Sub MultipleSolver()

Dim i As Integer

Dim o As Integer

ActivateWorkbook.ActivateSheet.Activate

For i = 36 To 37

For o = 39 To 51

SolverReset

SolverOk SetCell:="$C$" & i, MaxMinVal:=3, ValueOf:=0, ByChange:="$H$" & o

SolverSolve True

Next i

Next o



End Sub

**Fluff13** · 09-01-2022, 10:10 AM

The Next o line needs to go before the Next i

**Juhl94** · 09-01-2022, 10:12 AM

Awsome! didnt realise that...
Sadly it now says "Object required"?

**Fluff13** · 09-01-2022, 10:23 AM

On which line?
You can also get rid of this line as it doesn't do anything

Please Login or Register  to view this content.

**Juhl94** · 09-01-2022, 10:25 AM

It worked when i removed that line! i just tryed to follow a youtube vid! Thanks alot!

**Fluff13** · 09-01-2022, 10:27 AM

Glad to help & thanks for the feedback.
Just noticed that it should actually have been

Formula:

Please Login or Register  to view this content.

but as I said it's not needed.

"invalid next control variable reference" While trying to compile.

LinkBack

Thread Tools

Rate This Thread

Display

"invalid next control variable reference" While trying to compile.

Re: "invalid next control variable reference" While trying to compile.

Re: "invalid next control variable reference" While trying to compile.

Re: "invalid next control variable reference" While trying to compile.

Re: "invalid next control variable reference" While trying to compile.

Re: "invalid next control variable reference" While trying to compile.

Thread Information

Users Browsing this Thread

Similar Threads

Simple Nested Loop Keeps Giving "Invalid Next control variable reference" Error

[SOLVED] Why am i getting "Compile error: Invalid ReDim"

[SOLVED] VBA Noob, "Compile Error: Invalid Use of Property" On First line of Code (great..)

Changed code and now get " Invalid next control variable reference

Compile error: Invalid Next control varibale reference

[SOLVED] Debugging - Compile error: Invalid Next control variable reference

Compile Error: Invalid Next Control Variable Reference

Bookmarks

Bookmarks

Posting Permissions