VB code to put page numbering on a spreadsheet

[cassidybklyn]

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.

 

[PHV]

Straight from the VBA help:
Worksheets("Sheet1").PageSetup.CenterHeader = "&D page &P of &N"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cassidybklyn]

Thanks PH.
I'll give a shot Monday.
Enjoy your weekend.
Cassidy

 

[SkipVought]

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,

_[red][/red]

 

[cassidybklyn]

Skip,
you are right; I didn't look hard enough.
Thanks.
C.

 

[SkipVought]

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,

_[red][/red]