I have a macro made for a spreadsheet. It used to work, until I began adding new rows. Since the macro was told to select, say, A1:A20, and now i have an extra row, that row will not be selected. Is there any way to make this condition A1:A'X', leaving X a variable, hence allowing the macro to work with any number of rows?