creating new worksheet tab issue

I am trying to copy paste special values on tab "april 2010". That works. Next I'm trying to create a new tab. That works. Then I want to move some data from April 2010 onto the newly created tab. That does not work. It gives me a subscript out of range error at:

Please Login or Register  to view this content.

What am I doing wrong with regards to moving the data once the second tab has been created? Also is there anyway to do this without selecting everything? I know that's 'slow'.

Please Login or Register  to view this content.

You have a space in the worksheet name in one place in the code and no space in the worksheet name in the other:
OpenOrders
Open Orders

I fixed that but now it fails at:

[code]wks.Range("A75:ca104").Select[code]

error msg is select method of range class failed

Please Login or Register  to view this content.

it doesn't like

Please Login or Register  to view this content.

pastespecial method of range class failed

never mind. i changed the range to "a1:ca29" and it worked