Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB code to put page numbering on a spreadsheet

Status
Not open for further replies.

cassidybklyn

Programmer
Apr 23, 2007
82
US
Gentlemen, please bear with me. I learned that you can ask more than one question in one thread.

how can I use vb code to put page numbering on a spreadsheet?
Example:

Page 1 or 2.
Thanks.
C.
 
Straight from the VBA help:
Worksheets("Sheet1").PageSetup.CenterHeader = "&D page &P of &N"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thanks PH.
I'll give a shot Monday.
Enjoy your weekend.
Cassidy
 




Cassedy,

What's going on?????

You are asking questions that you should ALREADY know how to find the answers for.

This is ALL in Page Setup!!!!

Skip,

[glasses] [red][/red]
[tongue]
 




Cassidy,

It's generally more difficult to PROGRAM an application like Excel, before you understand how the application works. You really ought to have a thorough understanding of the functionality that you want to code, before doing so.

In other words, your lack of knowledge about how Excel works in your areas of interest, is a real detriment to your ability to produce good results, even with help, IMHO.

Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top