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?


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=571762