fill excel with format

I

iccsi

I retrieve data from MS Access and fill Excel spreadsheet.

After data filled on the spreadseet, The border of spreadsheet does
not change accordingly.

For example, the spreadsheet has a bold border on the result area for
100 rows. If the records returned more or less than 100 rows the
border still keep for 100 rows.

Are there any way to redraw the border according to the results set?

Your information is great appreciated,
 
K

Klatuu

If you are doing this from Excel, you should ask the question in an Excel
newsgroup. I am sure you will find knowledgable help there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Row heights change when printing bug? 1
How to Build an SQL Query on the Fly for Data Export to Excel 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Getting Excel To Access 4
Product Suggestion: lock border and cell formatting only 2

Top