Prev: date format
Next: Break Occuring with no Break Point
From: iccsi on 2 Jul 2008 13:44
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,

From: Klatuu on 2 Jul 2008 17:16
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.
--
Dave Hargis, Microsoft Access MVP


"iccsi" wrote:

> 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,
>
>
 | 
Pages: 1
Prev: date format
Next: Break Occuring with no Break Point