Code for Cut Paste each page to separate sheet
 

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

Code for Cut Paste each page to separate sheet
 

Ron de Bruin's code here may help you.

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

--
Jim
wrote in message
...
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