Here it is, I am sure you will get the idea, it only has message boxes telling you the row number which is stored in a variable.
It hasn't got application.screenupdatign set to false so that you can see it in action.