Excel numbering in a workbook
 

Hi

I currently have a excel workbook that has about 600 individual sheets. I
would like to hardcode a page number of each page. I don't really want to
enter the page numbers manually and was hoping that someone may have a macro
for this.

Any help will be greatly appreciated.

Excel numbering in a workbook
 

Hi,

Right click any worksheet tab, view code and paste this in and run it.
Change the range to where you want the number

Sub numberem()
For x = 1 To Worksheets.Count
Sheets(x).Range("A1").Value = x
Next
End Sub

Mike

"forest8" wrote:

Hi

I currently have a excel workbook that has about 600 individual sheets. I
would like to hardcode a page number of each page. I don't really want to
enter the page numbers manually and was hoping that someone may have a macro
for this.

Any help will be greatly appreciated.