I have a macro set up on the following file:
www.oksana-design.com/Spreadsheet.xls

If you scroll to W6, you will see the list of dates, and their
respective numbers underneath.
I have set up a macro so that when you push "Week Update," the dates
move over to the left along with their respective numbers underneath.
The macro works fine on this file. However, if I add any more rows
(right now the last row is 175) the macro stops working. It stops
working because of the fact that it only knows to change up to row 175.

How can I set up the macro so that it always conforms to the number of
rows in my table, and I don't have to manually change it everytime I
add a row?

Thank you.


--
piano.lisa
------------------------------------------------------------------------
piano.lisa's Profile: http://www.excelforum.com/member.php...o&userid=37601
View this thread: http://www.excelforum.com/showthread...hreadid=572222