code for reordering sheets

[ammartino44]

Hello. Could someone explain what each line of this code is doing (as well as what the syntax means)? Also, I use the debugger and I was curious as to why I can't see the value of "Name" in the 9th line.

Please Login or Register  to view this content.

[Pauleyb]

I don't think anyone wants to go through line by line with comments, and it seems like you are well on your way to understanding it by using the debugger (which would have been my initial response). Watch what it does and you should be able to determine what is going on. The code is using a simple 'bubble sort' technique, and if you Google that term you will find many demonstrations on that method. That is probably what you need help in understanding.
As for "Name", it is not a variable on its own. It is an instance variable within the Sheets class. So, debugging for "Name" is not enough information, you need to help by telling it which Name you are looking for (e.g. Application.Sheets(3).Name).