I posted something on here yesterday, and I got very good responses. However,
after I implemented each suggestion into VBA the macro worked only about 10
times. After that it came up with an error that said the worksheet could not
be copied...or something like that. This is what my code for that section
looks like...

This is at the beginning of my macro...what I need to do is copy a
worksheet. That's all I need to do...and it won't work...ANY SUGGESTIONS???


Sheets("201").Copy After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = InputBox("Enter the number of the new
distributor.")

Thanks,
Elise