Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 01-30-2019, 06:42 AM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
Join Date: May 2018
Location: Philippines
Posts: 171
Marcia is on a distinguished road
Default Bottom border on every page break

Hi there, I prepare an average of 13 financial reports every month. Some of the reports consist of several pages.These reports are presented in a four column format, each column is banded with a top, left and right border. Before I print a report, I add a bottom border that connects the left and right borders in every page break. When a row is filtered in or filtered out, I must delete the initial bottom border and draw another one at each of the adjusted page break. My brain usually goes on shutdown from the tedium of manually typing a border. I am sure that a macro can perform this task but my knowledge of macro is next to nothing. Please help. A sample format is attached. The macro should run on selected sheets only. Thank you.
Attached Files
File Type: xlsx Bottom Border.xlsx (32.9 KB, 2 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table bottom border not performing well herpez Word Tables 2 01-16-2017 03:43 PM
How to extend a table bottom border to the end of the page mikemike616 Word VBA 1 08-20-2015 08:08 PM
Paginate table so cell headings appear top of page instead bottom page when no room bottom page mtcn Word Tables 5 12-11-2014 12:49 PM
"First column" in word table page break border mj1856 Word Tables 1 04-25-2012 03:21 AM
Anchoring a section break to the bottom of a page, and having a table pass over it??? h3rk Word Tables 1 11-20-2009 07:34 AM

All times are GMT -7. The time now is 03:06 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft