Ya its right...you can run this macro without worrying about number of lines in Sheet 2....