Error 400 In Loop

[ajocius]

The loop below continues to give me an error 400. The last statement prior to the Next flashes a dialog box with just 400 on it. Have done all sorts of things to resolve this error. To include:
(1) a and b from Integer's
(2) changed from Next a to Next
(3) tried to select range but this selection became to complex

Basically I need to select a row, one at a time (total approx 2000) and move it to the right 1 cell. After about 126 loops the loop sends the 400 message.

Please Login or Register  to view this content.

[jeffreybrown]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[ajocius]

Sorry, lets try again.

[HaHoBe]

Hi, ajocius,

please note that the End-Tag is not correct - it`s not [ code/ ] but shoud be [ /code ] (without blanks).

I donīt see the need for a loop here:

Please Login or Register  to view this content.

Ciao,
Holger

[ajocius]

Holger,

Touchdown - Chicago Bears

This works perfectly. Wow that was easy. Perfect example of a lessons learned. Thanks Holger again for solving a nagging problem. Take care and God bless.

Tony