Thread: Code for Cut Paste each page to separate sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
  
Posts: 533
Default 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


Reply With QuoteReply With Quote