Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workbook page numbering | Excel Discussion (Misc queries) | |||
Auto numbering in each sheet of a workbook | Excel Discussion (Misc queries) | |||
Turn Off Continuous Page Numbering in Workbook | Excel Discussion (Misc queries) | |||
Page numbering for a whole WorkBook | Excel Worksheet Functions | |||
Numbering sheets in workbook | Excel Worksheet Functions |