Looked at your cell descriptions wrong thinking you were adding a new
column when you are adding a new row. So you want the bottom 5 rows.
look in the archives to find the XL go to bottom of sheet then XL up
to find last row. Then set the range by offset up the 5 rows to get
the current cell position. That may work for you. Should be some
examples there or google it. But there are some xperts here that can
write this code in a minute. Or try the PeachExcel list they have lots
of code like this.