Thread: Copy & Paste
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nc nc is offline
external usenet poster
 
Posts: 119
Default Copy & Paste

1. Set sourceRange = mybook.Worksheets(1).Range("A1:L60")
2. Set destrange = basebook.Worksheets("Form temp").Range("A1")

3. sourceRange.Copy destrange

How can I change statement 3. above to copy and paste only values and number
format?