fill excel with format

  • Thread starter Thread starter iccsi
  • Start date Start date
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,
 
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.
 
Back
Top