Thread: can't copy a sheet within same workbook
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Woody[_3_] Woody[_3_] is offline
external usenet poster
  
Posts: 14
Default can't copy a sheet within same workbook
"Norman Jones" wrote in news:
:

Sheets("WP_DETAIL").Copy After:=Sheets("WP_DETAIL")
Set oSummarySheet = ActiveSheet


Thanks Norman, that worked perfectlty. Much better than my workaround of
making a blank sheet and copy/paste from source to target.

Woody
Reply With QuoteReply With Quote