Thread: VBA code to copy and paste by values from one Excel workbook to another
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Nhien Nhien is offline
external usenet poster
  
Posts: 5
Default VBA code to copy and paste by values from one Excel workbook to another
On Aug 15, 1:33 pm, "Dan R." wrote:
Nhien,

Put this before your select statement:

ws.Parent.Activate

--
Dan

It worked. Thanks Dan for all your help.

- Nhien

Reply With QuoteReply With Quote