pdevries
May 23rd, 2001, 04:02 PM
I can't quite get newly added Excel worksheets to go to the end of the line. I can do it perfectly backwords though. My problem is with the Add method of the collection. I've found nothing on how to effectivly use it. My understanding of it so far is that you supply the index number of the worksheet you want to either insert before or after and use the appropriate argument (ie. .Add 1
for insert before or .Add , 2
to add after). All it does when I use that (replacing the numbers with the correct last item's index) is reuse the one sheet that's already in the workbook--it doesn't add any. I've tried using the .Move method with the .Add method using no arguments but I can't seem to get that to work at all. Any suggestions?
for insert before or .Add , 2
to add after). All it does when I use that (replacing the numbers with the correct last item's index) is reuse the one sheet that's already in the workbook--it doesn't add any. I've tried using the .Move method with the .Add method using no arguments but I can't seem to get that to work at all. Any suggestions?