View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pickytweety pickytweety is offline
external usenet poster
 
Posts: 57
Default Moving rng of wrkshts to new workbook

Hi,
I have a worksheet named "Start" and a worksheet named "End". In between
these two worksheets there are a series of other worksheets that a macro
builds. The number of sheets and the names of the sheets change depending on
a macro that is run. How do I select all the sheets between "Start" and
"End" and move them (not copy, but move) to a new workbook?
--
Thanks,
PTweety