Highlight the current set of data, all of it, and press CTRL-L to turn
the current dataset into an Excel "List". You'll see a box around the
data and a star (*) in the blank row below the last set of data.

If you start to type in the blank row, Excel will extend the list down
to that row and copy all the formatting and formulas from the last row
into this new row. Very convenient.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54903