Posted to microsoft.public.excel.misc

Jurassien

external usenet poster

Posts: 24

Copying and Pasting Macro

Hello,

I need helps on creating a macro that will copy and paste specific range
(E2:V200) from Sheet1 to Sheet 2 and so on. The script that I have does not
seem to working. Please Help!

Sub DoCopy()
Dim szRange As String
szRange = "E2:V200"
Worksheets("Data").Range
(szRange).Copy Destination:=Worksheets
("sheet2").Range(szRange)
End Sub

Thanks,

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
Copying and Pasting Rows Macro	tnederlof	Excel Discussion (Misc queries)	1	February 2nd 07 05:23 PM
Copying and pasting with macros	mCassidy	Excel Discussion (Misc queries)	2	January 3rd 07 02:06 PM
Copying Data from Access to Excel in a macro	GLS	Excel Worksheet Functions	2	November 15th 06 03:47 PM
Pasting a value not a formula in a macro	Alec H	Excel Discussion (Misc queries)	1	February 23rd 06 10:58 AM
Copying and Pasting between Workbooks	NothingButRomance	Excel Worksheet Functions	0	May 13th 05 07:33 PM

All times are GMT +1. The time now is 07:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us