Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2019, 06:42 AM
Marcia's Avatar
Marcia Marcia is offline Bottom border on every page break Windows 7 32bit Bottom border on every page break Office 2007
Expert
Bottom border on every page break
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
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, 8 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bottom border on every page break 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
Bottom border on every page break 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft