Posted to microsoft.public.excel.programming

Rowan[_2_] Rowan[_2_] is offline

external usenet poster

Posts: 226

Copy Method

I was just wondering why this line of code works:

mySht.Range("A5:A" & endRow).Copy

while this one produces runtime error 1004

mySht.Range(Cells(5, 1), Cells(endRow, 1)).Copy

Regards
Rowan

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
Method 'Copy' of object'_Worksheet failed	q2w3e4r	Excel Worksheet Functions	1	February 7th 07 01:17 PM
worksheet copy method	Marek	Excel Programming	1	September 6th 04 04:40 PM
Looking for faster method for Copy & Paste	David Copp[_4_]	Excel Programming	5	August 25th 04 04:32 AM
Copy Method of Worksheet Class Failed	Steph[_3_]	Excel Programming	0	April 5th 04 11:12 PM
Copy method fails in IIS	Domien	Excel Programming	0	February 19th 04 02:46 PM

All times are GMT +1. The time now is 07:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us