The "active" region of my worksheet has thick borders around the
periphery of the region, and thin cell borders everywhere inside the
region. When the active region is long and breaks across multiple
pages, the internal borders that appear at the page break remain thin.
I find myself manually changing these borders from thin to thick so
that each page has has a thick border around the periphery of that
page itself. Is there any way to make this occur automatically,
especially as rows may be inserted or deleted and the page break moves
to a different row boundary?
Thanks in advance for any help,
Fred Holmes
Jim Cone - 18 Mar 2005 21:01 GMT
Fred,
It could get very messy trying to do this with VBA.
It might be better to go to PageBreak Preview and
select all of the cells at the bottom of each page,
(using the Ctrl key). Then you only have to use the
format command just once.
Regards,
Jim Cone
San Francisco, USA
> The "active" region of my worksheet has thick borders around the
> periphery of the region, and thin cell borders everywhere inside the
[quoted text clipped - 7 lines]
> Thanks in advance for any help,
> Fred Holmes