I do not know how to word my problem so let me explain the process...

From an access DB a user pushes a button then an excel document is
built and populated using the excel object. The formatting is done
automatically (I recorded a macro and edited the code). Columns A:G are
selected then the border is placed down the entire columns.

I would like to format the .xls document better. How can I limit the
border to where the borders stop on the last row of data on the .xls
doc?

Any ideas or tips will be greatly appreciated.