Thread: vba to move and renaming data within a workbook
View Single Post
  #6   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
Morning Ron

Cheers for the code, inserting the additional lines and deleting the columns
works fines however the the pasting of the copied cells doesn't seem to work?
any ideas.

Cheers for your help,

David


Ron de Bruin wrote:
Oops

To insert the rows use

WSNew.Range("A1:A4").EntireRow.Insert

Hi

[quoted text clipped - 38 lines]

David

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