Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-25-2023, 04:59 PM
bblelli bblelli is offline Run a macro from page x to page Y Windows 10 Run a macro from page x to page Y Office 2021
Novice
Run a macro from page x to page Y
 
Join Date: Feb 2023
Posts: 22
bblelli is on a distinguished road
Question Run a macro from page x to page Y

Dears,



How can I run a specific VBA code to format some tables from a given page range?

My code is working perfectly, it's formatting the tables correctly, but now I would like to let the user determine the range of pages to apply and run the macro.
So, in this case, the macro won't format the entire document, the macro will only format the pages that are in the given page range.

For example, my document has 500 pages, and everypage has a table. But I would like to format the tables from pages 100 to 200, so, the macro will only format the tables from page 100 to 200. The macro will not format the tables from pages 201 to 500.

Thanks
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a macro from page x to page Y inserting a page break after each 9th page? or skip print on the 10th page ? vender Mail Merge 2 05-27-2020 05:18 AM
Custom page size - Page color not covering entire page when converting to PDF icor1031 Word 9 12-09-2019 08:21 PM
Run a macro from page x to page Y Start page number on page 3, go to page not working properly MetroBOS Word 7 01-30-2016 11:31 PM
2 page document printing problem, text from page 1 in layout of page 2 when printed laurawether45 Word 1 08-02-2012 07:03 AM
Run a macro from page x to page Y MS Word, page goes to next page when entering data on previous page munna94 Word 2 12-30-2010 08:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:42 PM.


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