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.


--
syuhas
------------------------------------------------------------------------
syuhas's Profile: http://www.excelforum.com/member.php...o&userid=27486
View this thread: http://www.excelforum.com/showthread...hreadid=517364