Sounds like you're trying to do something similar to what I'm doing ...
if you're reading this on excelforum.com, browse down to my thread --
I'm creating new worksheets dynamically based on a list of names (or in
this case you're using a list of numbers, but it should be similar).
This is necessary if you don't know how many meetings there are ahead
of time, and want the worksheet to create them dynamically.
If you want the original tip that I used to help create that, do a
google search on "excel new worksheet" and there should be an
exceltip.com link there. :)
-Joe
---
Message posted from
http://www.ExcelForum.com/