Thread: Selecting data to copy and paste
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Selecting data to copy and paste
Hi Black country boy,

If your workbook has previously been saved, change:

Set WB = Workbooks("Book1") '<<==== CHANGE

to

Set WB = Workbooks("Book1.xls") '<<==== CHANGE



---
Regards,
Norman


Reply With QuoteReply With Quote