Excel VBA: Count Number of Print Pages on a Worksheet

preview_player
Показать описание
In this video, we solve a question that was asked by one of our viewers recently - how to count the number of print pages on a worksheet using Excel VBA.

More specifically they wanted a list of a range of sheet names in a workbook, and the number of print pages for each of those worksheets.

This was not something (I believe) that I had done before. But it did not take long to find a solution that would work.

I thought this would be a great challenge for those of you starting, or are early, on your journeys to learn Excel VBA.

You can download the workbook from the link below and try and solve the question yourself.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

  1. Computergaga
  2. Microsoft Excel
  3. Excel VBA
  4. Excel Macros
  5. Visual Basic for Applications
  6. Print Pages
Рекомендации по теме
Using Count in 0:03:52

Using Count in Excel VBA (Macro) - Most Common Uses and the Code is Included

Excel VBA: Count 0:07:07

Excel VBA: Count Number of Print Pages on a Worksheet

How to Count 0:03:36

How to Count the Occurrences of a Number or Text in a Range in Excel : Using Excel

Excel VBA - 0:04:01

Excel VBA - Excel Count Function in VBA Code

Mastering Excel VBA 0:02:29

Mastering Excel VBA Count Sheets, Rows, Columns and CountA Worksheet Function - CODE INCLUDED

How to count 0:00:26

How to count unique values Excel

Count and CountA 0:08:07

Count and CountA in VBA Excel

Excel VBA - 0:03:03

Excel VBA - Rows & Columns Count

Master Excel 2024: 0:37:27

Master Excel 2024: VBA Basics, Variables, and If Statements for Automation 🚀

Using Count and 0:06:58

Using Count and CountA in Excel - Excel Tutorial

Count Number of 0:09:36

Count Number of Print Pages on Worksheet with VBA

VBA to Count 0:08:07

VBA to Count Cells with Specific Text - Count Cells with Criteria

Excel - Do 0:03:24

Excel - Do a Count of Unique Values | Text and/or Number | Get a Count of Unique Values in Excel

Count the number 0:02:32

Count the number of unique values in a column with VBA

#2 VBA- Excel 0:04:01

#2 VBA- Excel Count Function in VBA Code

VBA Complete Tutorial 0:03:02

VBA Complete Tutorial -Row Count

Excel VBA to 0:07:26

Excel VBA to Count Files in a Folder

VBA to Count 0:09:57

VBA to Count Number of Words in a Cell - VBA to Count Words in String

Count Number of 0:02:15

Count Number of Worksheets in a Workbook without VBA

Excel COUNTIF & 0:05:14

Excel COUNTIF & SUMIF On Colour - No VBA Required

How to Count 0:06:36

How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before)

Count Colored Cells 0:10:21

Count Colored Cells in Excel (using Formula or VBA)

How to SUM 0:10:41

How to SUM Totals At Bottom of a Column Dynamically - Excel VBA Is Fun!

How to Automate 0:02:37

How to Automate Row numbers in Excel?

Комментарии
Автор

Hello, thanks for information. But how i cant get de current page?

fabiogarces
Автор

very great, it's a job of a real professional
thank you Mr Alain

AbuTalha-eopr
Автор

Alan, thanks for your clean and efficient coding.
I used a Do While loop, an InputBox, the PrintOut method and two variables to get the page count.
howie

sawirusj
Автор

Very informative video. Good work on VBA programming. Looking more for it.

kvlpnd
Автор

Is there a link with the macro included?

ioannissakarelis
Автор

1)How to insert page numbers in each page of a PDF file and
2) how to repeat the row headers in eaxh page when excel is converted to PDF based on a row value

vamanshenoy
Автор

How many pages have I printed? What is the page count? store in databased using coding . plzz

saurabhmaurya