Hello & Welcome to the Forum,
"i" is just used as a variable. Some may say its just a lazy way to declare a variable, but its up to you the author.
It simply comes down to your coding style and how well you want the variable to represent what you mean.
http://support.microsoft.com/kb/843144
http://www.cpearson.com/excel/DeclaringVariables.aspx
http://stackoverflow.com/questions/1...best-practices
As far as the Range(Cells(x, y), Cells(x, y)), this would mean...
Range(Cells([RowIndex], [ColumnIndex]), Cells([RowIndex], [ColumnIndex]))
http://msdn.microsoft.com/en-us/libr.../ff194567.aspx
http://msdn.microsoft.com/en-us/libr.../ff838238.aspx
Take the example above. We established the last row by finding the last filled cells in column A and called it lngLastRow.
Normally I would just call it LR, but if I want to get more specific, the variable is declared as Long and it is the Last Row.
In the end, the code copies A1:J10
Bookmarks