Excel question

My Excel kung-fu is bad, like, not even a white belt.

I have a client-provided template that I cannot use VBA in. I'd like to insert the total number of worksheets into a cell, like &[Pages] in a footer. Is there a way?

Thanks...

what version of excel?? pre 2007 is reasonably different than 2007+

I know the 2005 is different that the 2006
'05 '06

I don't know of a way to do this without VBA. Could you write a function that does this, and then preps your file for the client by copy/pasting all your data into a new file (i.e. sans code)? I am taking a similar approach with a VBA spreadsheet right now, as the final output from my process needs to be a tab-delimited text file.

Office 2010.

Maybe I could use the VBA, then copy/paste the data only, save as a standard xlsx file, not macro-enabled, and deliver to client...

You can use an external workbook that does contain the code do the work and post it to the customers workbbok. Here's a quick example:
Sub Process_AWT()
CodeBook = ThisWorkbook.Name'this is the workbook containing the code
ReportBook = ActiveWorkbook.Name'this is the customer workbook

ReportSheetCount=ReportBook.Worksheets.Count

This can be very useful as all of the power can be kept in a container workbook and called when needed from the working document, without having to add code to a bunch of documents.

Steve Stafford