Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
letters instead of numbers for pages
Is there a way to use letters instead of numbers for page numbering?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
letters instead of numbers for pages
Give this a shot - in a std module
Sub UseLetters() ActiveSheet.DisplayPageBreaks = True Pgcount = ActiveSheet.HPageBreaks.Count + 1 CvNum = 64 For c = 1 To Pgcount With ActiveSheet.PageSetup .LeftFooter = "This is Page " & Chr(CvNum + c) & " of " & Chr(CvNum + Pgcount) End With ActiveSheet.PrintPreview 'Or ActiveSheet.PrintOut Next c End Sub "Cotton" wrote: Is there a way to use letters instead of numbers for page numbering? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers instead of letters | Excel Discussion (Misc queries) | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
Letters = Numbers | Charts and Charting in Excel | |||
corresponding numbers and letters | Excel Discussion (Misc queries) |