Thread: vba to move and renaming data within a workbook
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ozzie via OfficeKB.com Ozzie via OfficeKB.com is offline
external usenet poster
  
Posts: 41
Default vba to move and renaming data within a workbook
Hi Ron,

No, I need to copy the cells from each sheet, and paste them into D1 before
we delete columns A:C

WSNew.Range("A1:C2").Copy WSNew.Range("D1")

I tried adding the paste function by the line of code above, but can't seem
to do it?

Thanks for your help,



Ron de Bruin wrote:
Hi Ozzie

Do you want to copy the cells from ws1 to the sheets?

Morning Ron

[quoted text clipped - 17 lines]

David

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200602/1
Reply With QuoteReply With Quote