View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default limit on number of worksheets

Do you copy sheets to add, or insert NEW one.

There is a bug when you copy sheets
instead insert, new sheet, then copy info
JY
"Maggie" wrote in message
ups.com...
I was wondering if there was a limit on the number of worksheets that
are inserted in through a macro. I can only get 35 worksheets and I
need to get 50-60 worksheets. Once I try to enter the 36 worksheet
and error 400 comes up. any suggestions to fix this would be greatly
appreciated.

Maggie