Thread: Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_39_] Matt[_39_] is offline
external usenet poster
  
Posts: 27
Default Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined
Trying to copy the contents of Sheet 2 starting at cell A2 to Cell B2
on Sheet 1
Here's what I have:

Worksheets("Sheet 2").Range("A2", _
Cells(Worksheets("Sheet 2").UsedRange.Rows.Count, _
Worksheets("Sheet 2").UsedRange.Columns.Count)).Copy _
Destination:=Worksheets("Sheet 1").Range("B2")

This results in Error '1004' Application Defined or Object Defined.
Anythoughts on how to fix this?

Reply With QuoteReply With Quote