Code for Cut Paste each page to separate sheet

's Computer Specifications

Friend,

I have an excel sheet having more than 30 pages (if printed). Now I
wants to cut and paste each page into a separate sheet in the same
file.

Can anyone please help me to create a code / macro for this purpose.

Thanks in Advance.

Rakesh

's Computer Specifications

Ron de Bruin's code here may help you.

http://www.rondebruin.nl/hpagebreaks.htm

--
Jim
<(E-Mail Removed)> wrote in message
news:0d340e40-cec1-4245-a923-(E-Mail Removed)...
> Friend,
>
> I have an excel sheet having more than 30 pages (if printed). Now I
> wants to cut and paste each page into a separate sheet in the same
> file.
>
> Can anyone please help me to create a code / macro for this purpose.
>
> Thanks in Advance.
>
> Rakesh

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help to code Macro to Copy fron one sheet and paste in other sheet	kay	Microsoft Excel Programming	3	25th Jul 2008 06:46 PM
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations....	Corey	Microsoft Excel Programming	4	25th Nov 2006 04:57 AM
lookup and paste row into separate sheet	lmc	Microsoft Excel Misc	2	1st Apr 2004 02:53 PM
Referencing web page in separate code file	=?Utf-8?B?U3B5cm9zIFNha2VsbGFyaWFkaXM=?=	Microsoft ASP .NET	1	27th Jan 2004 10:29 AM
copy and paste from different sheets into one sheet using a VB code	reena	Microsoft Excel Programming	2	5th Aug 2003 02:49 PM