panta rhei Posted January 27, 2009 Share Posted January 27, 2009 It seems that the criterion for worksheets does not work. Eg. MESSAGE(COUNT(T=SPRDSHEET)); returns zero regardless of the number of worksheets. I guess I have to walk through the name list... Again... Quote Link to comment
Pat Stanford Posted January 27, 2009 Share Posted January 27, 2009 Count(T=56) will get you the number of worksheets that are visible on the drawing. I think I have some code around that counts the number of worksheets, but I can't find it right now. I will look more in the morning (California time). Quote Link to comment
panta rhei Posted January 27, 2009 Author Share Posted January 27, 2009 Pat, I don't actually want to count worksheets but to do things with them. SNAFU, but now sorted out. It's just so irritating to RTFM and then find out that it is BS. Petri Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.