There are a number of ways of doing this. Which way fits you depends on the
layout of your data. What would you say to a person if you were telling him
how to determine what rows to select? Post your code when you respond. Not
the file. Just the pertinent code. HTH Otto
"aposatsk" wrote in
message ...

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