Thread
:
Copy & Paste
View Single Post
#
1
Posted to microsoft.public.excel.misc
nc
external usenet poster
Posts: 119
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?
Reply With Quote
nc
View Public Profile
Find all posts by nc