For control variable already in use

[Otto Moehrbach]

Excel 2007, Win 7 64-bit
I have the following code. Note that this is a self-standing macro. This
macro is not called by any other macro. It is executed by a Forms button.
There are 3 FOR loops, none nested

Sub SortByName()
With Sheets("SortSht")
Copy & Paste
Set rColA =...................
For cc = rColA.Count To 2 Step -2
Stuff
Next cc
For cc = rColA.Count To 1 Step -1
Stuff
Next cc
For cc = rColA.Count To 1 Step -1
Stuff
Next cc
End With
End sub

I get an error with the bottom FOR loop. Error reads "For control variable
already in use". I change the variable in that FOR loop to "c". I get the
same identical error but now in the second FOR loop. What is wrong with
this code? Thanks for your time. Otto

 

[Barb Reinhardt]

Have you declared all of your variables?

Barb Reinhardt

 

[OssieMac]

Hi Otto,

Without seeing what code you have in "Stuff' I am guessing that you might
have got something like an End With and Next out of order somewhere or maybe
another For/Next and have mixed up their order by having Next addressing the
wrong variable. eg. Next cc where next c should be.

If you can't find the problem then can you post all of your code.

 

[Otto Moehrbach]

Barb & Ossie
Yes, I declared all my variables and have "Option Explicit". The
"Stuff" is simple copy/paste code with no For loops or Withs/End Withs.
That is what is so perplexing about this. The entire macro is a very simple
macro consisting of nothing more than moving data around. Thanks for your
time. Otto

 

[Otto Moehrbach]

Found it!!!
I wrote this code for an OP. He was having this problem. I found out this
morning that I was NOT having this problem with the same file. I sent him
mine and all is well. I figure his code got corrupted. Thanks again. Otto