Thread: can't copy a sheet within same workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_31_] dominicb[_31_] is offline
external usenet poster
  
Posts: 1
Default can't copy a sheet within same workbook

Good evening Woody

I think you're making life a bit more difficult for yourself - which is
often the way with VBA - but this can be done fairly simply. Try this:

Sheets("WP_DETAIL").Copy After:=Sheets(1)

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=380253

Reply With QuoteReply With Quote