View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphinv4 Dolphinv4 is offline
external usenet poster
 
Posts: 27
Default Select the ActiveSheet & the sheet next to it

Hi,

how do I have a macro to select the activesheet and the sheet next to it and
then to copy them and insert as new sheets (both of them)? Note that for the
macro, i do not want it to have specific Named sheets.

Thanks.