Thread: Why Copy/Paste fails using Offset & Resize of myRange?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
  
Posts: 391
Default Why Copy/Paste fails using Offset & Resize of myRange?

Got it!

myRange.Offset(0, 5).Resize(, 1).Copy Sheets("1200").Range("A" & myRow)


Thanks for any who spent time.

wrote:

myRange.Offset(0, 5).Resize(, 1).Copy ' attempt to disect a "column" in myRange for the Paste next

Sheets("1200").Range("A" & myRow).Paste
Reply With QuoteReply With Quote