Count Number of Print Pages on Worksheet with VBA

preview_player
Показать описание
How to count number of print pages on a worksheet with vba and print specific pages automatically.
Рекомендации по теме
Комментарии
Автор

How to do this same thing of counting pages with word doc. Please help 🙏🏻

honestindian
Автор

Thank you
I would like to know how specify a printer to be printed if I have already two or three setup printers?

abdanomer
Автор

Sir
How can we loop through a folder and copy non contiguous cells or ranges from different sheets in multiple workbooks to my master sheet?
Your help and support is highly appreciated

jamalal-fayturi
Автор

counts the number of pages (except for pages with no data). how ?

anhnhatnguyet
Автор

सर अगर एक्सेल के हर पेज की अलग अलग pdf बनानी हो और उनका नेम भी उसे शीट से देना हो तो कैसे हो पाएगा। प्लीज हेल्प...

cpkanojiya
Автор

This Video is very useful. But if I have to Select Multiple Sheet i.e. sheet1, Sheet2 and Sheet3 by holding Control button, then how to know the total number of pages in a msg box or in a cell ?

let me expalin :
I have 4 sheet namely --- "Balance Sheet", "Trading Account", "Profit & Loss Account", "P&L Appropriation A/C" and a another sheet named "Invioce" .

"Balance Sheet" may be varies to 3 or 4 pages, Profit & Loss Account may be 2 or 3 pages.

I take Rs. 30 for each page being Composed by me along with the 1st Printout

I make a sheet named "Invoice" Page in which -- "b13" cell is "Total No of Pages", "D13" is "Rate per page " and "e13" is "Total amount"

Now I have to Count the Printable page of All the 4 sheets and should be written in the cell "b13" in the sheet named as "Invoice" to calculate the total amount of bill.

SUKANTA_BAGCHI
Автор

Hello Sir, How to create user Login form? i need user enter the user name and password then open excel sheet with press login button. how i do this? pls explain to me thank you

thajudeenkader
Автор

agher mai active x listbox mai saari sheet add karo phir mai un me se ek sheet kar ke oos ki total pages kitne he tou ap es pe ke tutorial banae sir

naveednak
Автор

Sir recently i joined YouTube. Plz can you to code for. A macro to extract source of each mail. To excel or in outlook itself. Where it can be. Plz..

rajandas