Nested loops problem

This is my first attempt at using vba. What I'm trying to do is find palindromes that are multiples of three digit numbers. I figured I'd start with 100 and multiply that by 100-999 then jump to 101 times 100-999 and so on untill 999-999 and excel check each number to see if its a palindrome.

I know my code is ugly but here it is.

Please Login or Register  to view this content.

I've added some comments but they most likely make the code hard to read.
While testing this out I tossed in message boxes to see what wasnt working and it appears the my second loop only happens once.




What I dont want is a solution to how to find the palindromes, what I would like would be if someone could explain why my second loop isnt restarting.

Hi Symplystyc
It looks like your y-loop is executing properly
Try using the Debug statement as follows and watch the Immediate window

Please Login or Register  to view this content.

Need some attention to your logic?

Barryleajo, I put in Debug.Print y and nothing happened. any suggestions.

and thanks shg I didnt even consider using For statements. but now I want to figure out what I did wrong with the Do statements.

Hi Symplystyc
Have you got your Immediate window in view?
In the VBE editor, open it from the View menu.
It will likely dock as a window at the bottom of the code window.
This is the only place that you will see anything "happen".
It should (does in my test) report the value of y each time it iterates the loop