- Jul 21, 2004
I want to be able to return the number of sheets in a workbook during a macro operation. My sheet uses macros to insert new sheets from templates, each sheet represents a seqential job number from a list on the original first sheet. Hence I want to use the count function to count number of sheets and use it in a lookup function as the worksheet is inserted. I can manipulate the basic part of the function into my existing macro - just don't know the exact wording of the code to use for this.