for example: total number of print page is 8
page 1 of 8
page 2 of 8
page 3 of 8
"
"
page 8 of 8
please help,thanks.
-
等级
本版专家分：0结帖率 88.89% -
hi,please help. how to count the total number of print page display at Sheets("label") range("G8").
for example: total number of print page is 8
page 1 of 8
page 2 of 8
page 3 of 8
"
"
page 8 of 8
please help,thanks.展开阅读全文
-
等级
本版专家分：2514 -
you should define a variable first.for example: dim i As integer
Then add 1 to i when you print.finally the variable i is the total number.
-
等级
本版专家分：0
-
current i'm able to count the total page of print.
but the problem now is,if there have 5 page to print the result come out is 1-5,cannot print out
2-5 pages,3-5 pages.
this is the current code:
Sub PageInfo()
Dim iPages As Integer
Dim iCol As Integer
Dim iCols As Integer
Dim lRows As Long
Dim lRow As Long
Dim iPage As Integer
iPages = Worksheets("label").Range("k3")
With ActiveSheet
If .PageSetup.Order = xlDownThenOver Then
iPage = (iCol - 1) * (lRows + 1) + lRow
Else
iPage = (lRow - 1) * (iCols + 1) + iCol
End If
End With
Worksheets("label").Range("g6") = iPage & " of " & iPages & " pages"
End Sub
please help.thanks.
-
等级
本版专家分：2514
-
where is the Loop Control?Just like For,While and so on.
- 1363: Count 101 （经典数位dp）
1363: Count 101 Submit Page Summary Time Limit: 1 Sec Memory Limit: 128 Mb Submitted: 393 Solved: 154 Description You know YaoYao is fond of his chains. He has...
- 能调试---(四)内存性能分析
UNIX中文宝库 http://www.douzhe.com 2005年04月05日 作者: 转自: 点击: 1888 1:内存管理 2:衡量内存闲忙程度的指标 3:内存资源成为系统性能的瓶颈的征兆 4:什么地方/哪些进程是占用内存资源的大户?...
- Linux：查找目录和子目录中的文件数
Sometimes we want to find the number of files in a directory in Linux. For example, finding how many images are present in JournalDev WordPress uploads directory. 有时我们想在Linux目录中查找文件数。 ...
- 三、k近邻法--统计学习方法总结
三k近邻法 1 k近邻算法 2 k近邻模型 31模型 22距离度量 23 k值的选择 24分类决策规则 3k近邻法的实现kd树 31构造kd树 32搜索kd树三、k近邻法k近邻法（k-nearest neighbor, k-NN）是一种基本分类与回归方法。...
- [Request] Bring back total number of printed layers in GCODE viewer
3. Look for total number of layers to print <h4>What did you expect to happen? <p>Total number of layers to print would be visible <h4>What happened instead? <p>Total number of layers to print was not...
- LeetCode 简单算法题
使用Nodejs 抓取的LeetCode 简单算法题 一步一步来,先攻破所有简单的题目,有些题目不适合... Maximum Depth of Binary Tree|| Given a binary tree, find its maximum depth.The maximum depth is the number of n...
- count lines in a file - wc & nl
How to Count Number of Lines in a File in Linux (wc and nl Command Examples) 时间 2013-02-13 20:00:22 The Geek Stuff 原文 http://www.thegeekstuff.com/2013/02/wc-nl-examples/ 主题 Linux ...
- Getting Started with Kaggle: House Prices Competition
Getting Started with Kaggle: House Prices Competition Adam Massachi 05 MAY 2017 in tutorials, python, and kaggle Founded in 2010, Kaggle is a Data Science platform where users can share, ...
- LSD直线检测
代码来源：http://www.ipol.im/pub/art/2012/gjmr-lsd/ Files ----- README.txt - This file. COPYING - GNU AFFERO GENERAL PUBLIC LICENSE Version 3. Makefile - Com
- 如何准备机器学习数据集_机器学习演练第一部分：准备数据
如何准备机器学习数据集Cleaning and preparing data is a critical first step in any machine learning project. In this blog post, Dataquest student Daniel Osei’s takes us through examining a dataset, ...
- py_innodb_page_info工具使用
此工具是《MySQL技术内幕 ...此工具由三个文件py_innodb_page_info.py和mylib.py以及include.py组成。需要放在同一个目录下，chmod 755 这三个文件的权限。 #! /usr/bin/env python #encoding=utf-8 import mylib...
- MYSQL基础：参数调优:1:InnoDB调优参数基本信息一览
InnoDB、MyISAM 都是MySQL存储引擎，在InnoDB存储引擎中，page是最小单位，然后是extent（区），段（segment）和tablespace，和Oracle在名称上较为相似。
- prometheus监控插件mysqld_exporter
1，首先需要增加授权 mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'localhost' IDENTIFIED BY 'exporter123' WITH MAX_USER_CONNECTIONS 3;mysql> flush privileges;...
- sql语句分页多种方式ROW_NUMBER()OVER
方式一 select top @pageSize * from company where id not in ...top @pageSize*(@pageIndex-1) id ...方式二ROW_NUMBER()...--ROW_NUMBER() 就是生成一个有顺序的行号,而他生成顺序的标准,就是后面紧跟的OVER(ORD
- Analysis of spider data with python
*** I have been studying spider of Python and data analysis lately. Make a summary of the method and idea with actual cases today.*** ** First chapter 1. How to get data with python sp...
- Python模块大全
Python模块
- lodop 使用教程之图文详解 + 详细方法/参数的配置说明
lodop 使用教程之图文详解 lodop 详细方法使用介绍 lodop 详细参数设置介绍
- Spring Boot入门教程(四):配置文件
配置方式 每个starter都有自己默认的配置，如果需要改变默认值，可以在其他地方配置来覆盖掉默认的值，覆盖默认的配置有多种方式，每种方式的优先级也不同，如果在多个地方配置则优先使用优先级高的值，其中命令行...
- coursera-Capstone: Retrieving, Processing, and Visualizing Data with Python(Page Rank的作业）
以下是作业的题目：Page RankFirst you will spider 100 pages from http://python-data.dr-chuck.net/ run the page rank algorithm and take some screen shots. Then you will reset the spider process and ...
- The answers to the exercises of python in the platform of CodeStepByStep(update week13)
课程目录Page hierarchy一、Inclass exercises1.Week7_InClass1.expressions_number22.expressions_exam13.expressions_exam24.expressions_exam55.compute_pay6.define_grade_variable7.first_second8.first_second...
- sql语句分页多种方式ROW_NUMBER()OVER
sql语句分页多种方式ROW_NUMBER()OVER
- Assets Error Listings APP-OFA-XXXX (文档 ID 1460268.1)
转： https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=zm396viw3_9&_afrLoop=326564084785384 ...R11i to R12 Assets Error Listings for: APP-OFA-47039, ... APP-OFA-47169, APP-OFA
- Spring-boot配置文件属性大全（2.0.5版本）
# =================================================================== # COMMON SPRING BOOT PROPERTIES # # This sample file is provided as a guideline. Do NOT copy it in its # entirety to your own app....
- 小麦苗的常用代码--常用命令(仅限自己使用)
小麦苗的常用代码--常用命令(仅限自己使用) 囗 ■ ☑ ● • · ◆ ※ ☆ ★ ⊙ √ → innobackupex--help -? -h help=y sy...
- MsSqlServer
use MyItcast --求1--100的和 declare @sum int=0,@number int=1; while(@number ... set @number=@number+1; end select @sum --求1--100之间所有基数和 declare @sum int=0,@num in
- dbGet
You can use the following single-linedbGetscripts to explore various aspects of your design: List all unplaced instances in the design dbGet[dbGet-p top.insts.pStatus unplaced].name List all pl...
- Linux 的内存管理工具和调优参数
1. free2. top3. vmstat4. slabtop;5. pmap6. dmesg7. /proc/meminfo8.... sync10./proc/zoneinfo 11./proc/pagetypeinfo查看内存工具：1.freefree - Display amount of free and used memory in the sy...
- 学习python(六)
字典 字典的介绍 字典也是python中的一种重要的数据类型,这样就可以定义一个字典了: >>> apple = {'color':'red','size':'big','texture':'brittle'} >>>...{'color': 'red', 'size': 'big', '...
- 一些能提高ABAP开发人员日常工作效率的ABAP小工具
Some of them might not be so useful at first glance – I just write them for fun. Some of them could be used to improve work efficiency, to just reduce several mouse clicks – I am too lazy Tcode ...
- the bag of words representation —— Python Data Science CookBook
In order to do machine learning on text, we will need to convert the text to numerical feature vectors. The bag of words representation : the text is converted to numerical vectors and the column nam