Excel VBA to get the Print Preview page number for every sheet

I have an excel sheet which will keep on adding new worksheets or deleting existing one. The current VBA code, creates a table of content, with the page number for each worksheet. However instead of the page number, I need the first page number of the print preview page for each worksheet. Attached is the excel sheet, and in the cover worksheet, I have shown the correct and incorrect page#.

The excel works with a maximum of 50 worksheets, ad as the works sheets are more than 25, the next ones get added on the second part of the table in the cover worksheet. The VBA code that you build should be able to address both those columns (upto 50 excel worksheets). Also as new sheets are added, and the current macro is run, your macro, should automatically update the new page numbers [login to view URL] it in the next 8-10 hours. Ready to pay 1000 INR for this work.

Please include "Can get page#" as the first line of your bid.. Bids without this line will not be entertained.

Квалификация: Excel, Visual Basic, Visual Basic для приложений

Показать больше how to put page number in excel, how to insert page number in excel 2013, how to insert page numbers in excel 2010, excel vba print preview and print, how to add page numbers in excel for entire workbook, insert page number in excel not in header, excel page number formula, excel page numbers across worksheets, excel vba print autocount, excel vba save web page, excel vba check web page exists, excel macro print specific page, export excel vba results web page, excel macro print specific page sheet, excel vba print specified pages, excel vba click web page button, excel vba print tab xml, excel vba refresh web page, excel vba search web page, excel vba print menu select

О работодателе:
( 6 отзыв(-а, -ов) ) Mumbai, India

ID проекта: #18290125



Hello, I am ready to discuss project with you. Being experienced in working on excel vba projects extensively, I can help you in getting it done quickly and efficiently. I am available to start now and want to disc Больше

₹1000 INR за 1 день
(92 отзывов(-а))

3 фрилансеров(-а) в среднем готовы выполнить эту работу за ₹1133


Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

₹1300 INR за 1 день
(15 отзывов(-а))

Hi, I have relevant experience for more than 7+ years in Bookkeeping, General Ledger Accounting, Reconciliation and Management Reporting as required for this project. I believe in excellent customer experience an Больше

₹1100 INR за 1 день
(0 отзывов(-а))