Range("A5:G5").Select Range(Selection, Selection.End(xlDown)).Select
The files I will be using this code on differ in the # of rows so sometimes I will select A5:G100 and other times I might select A5:G150. I want to select one row less at the bottom. So in the first example, A5:G99 and in the second example, A5:G149. Help?