I know about page numbering in the header or footer, but I need some way to
put the worksheet number (if counted from left to right) and the total number
of worksheets in my workbook in cells on my worksheets.
Does anyone know how to program some funtions that I can put into cells
that I choose so that these numbers will automatically be generated and
changed, even if I remove or add a worksheet, or change the order of the
worksheets in the workbook (from left to right), without having to run a
macro all the time.

Chris Hofman