Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined

Posted to microsoft.public.excel.programming

Matt[_39_] Matt[_39_] is offline

external usenet poster

Posts: 27

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run-time error '50290': Application-defined or object-defined erro	Macro button	Excel Discussion (Misc queries)	1	March 12th 09 10:59 AM
Runtime error 1004- application defined or object defined erro	Novice	Excel Programming	0	February 6th 06 09:34 PM
Runtime error 1004- application defined or object defined erro	Novice	Excel Programming	1	February 6th 06 09:33 PM
Runtime error 1004- application defined or object defined erro	Jim Thomlinson[_5_]	Excel Programming	0	February 6th 06 09:29 PM
Range - Application Defined or Object Defined Error	Dyl	Excel Programming	6	October 31st 05 07:57 PM

All times are GMT +1. The time now is 09:49 PM.

Menu

About Us