add worksheet

Originally Posted by matrixacc

Set xlWorkSheet = xlWorkBook.Worksheets.Add 'after:=(Worksheets.Count)

after:=(Worksheets.Count) is for one or another reason not allowed after .Add method ?

I don't understand, the code that I posted works. You have an apostrophe before after so that will not work.