Maybe with some complex VBA but when would you change from 1a, 1b to 2a and not
1c?
I would just copy over to Word and print out from there.
Word has many more options when numbering pages and you could get what you want.
See this article...............
http://office.microsoft.com/en-us/wo...165141033.aspx
Gord Dibben MS Excel MVP
On Mon, 13 Nov 2006 13:16:03 -0800, vizhen
wrote:
is it possible to number pages with letters and numbers. such as 1.a., 1.b.,
2.a etc