View Single Post
 
Old 02-25-2023, 04:59 PM
bblelli bblelli is offline Windows 10 Office 2021
Novice
 
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