Posted to microsoft.public.excel.programming

No Name

Posts: n/a

Copy Paste in Macro

How do I reduce the coding involved in this statement.
FinalRow is just an integer value. Thanks you

Range("A2:D" & FinalRow).Select
Selection.Copy
Range("E2:H" & FinalRow).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A2").Select

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
HELP with macro for copy and paste	RedOctagon	Excel Discussion (Misc queries)	0	October 13th 06 02:54 PM
HELP with macro for copy and paste	RedOctagon	Excel Discussion (Misc queries)	0	October 13th 06 02:54 PM
Copy & Paste macro	sparx	Excel Worksheet Functions	3	September 13th 05 05:08 AM
Copy and Paste Macro Help please....	andy F	Excel Programming	2	December 14th 03 09:49 PM
Macro Won't Copy/Paste	-JB-[_3_]	Excel Programming	1	October 2nd 03 10:49 AM

All times are GMT +1. The time now is 08:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us