I am trying to add a line between the last selected cell and the current
cell (in the same column), and I don't know the syntax on that. The
recorded macro just went to the same spot every time and didn't move
along with the new data. What I'm really trying to do is to have the
worksheet automatically add a line between the previous cell and the
current cell, when a new month has been entered. Is it possible?


Ex:

| A | B |
|---------------|----------------|
1| 11/10/04 | |
--|---------------|---------------|
2| 12/01/04 | |
3| 12/05/04 | |
--|-------------------------------|
4| 01/05/04 | |


--
Jeff Roper
------------------------------------------------------------------------
Jeff Roper's Profile: http://www.excelforum.com/member.php...o&userid=16293
View this thread: http://www.excelforum.com/showthread...hreadid=277324