LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Copying sheets without copying named ranges

I have a workBOOK with named ranges in it, and want to copy a workSHEET out
of it into a new workBOOK without taking the range names into the new
workBOOK. The new workSHEET doesn't have any named ranges in it, but when I
copy it to a new workBOOK (also without named ranges), it copies all of the
names from the original workBOOK into the new workBOOK.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Worksheets which contain Named Ranges Terry Bennett Excel Worksheet Functions 0 June 25th 09 05:04 PM
copying named ranges to other sheets Chris Excel Programming 0 August 6th 07 01:50 PM
Copying Named Ranges Tom Perlman Excel Discussion (Misc queries) 4 December 14th 06 07:34 PM
Copying named ranges from one sheet to another Mark Stephens Excel Programming 3 August 4th 05 02:54 PM
named ranges and copying sheets to another workbook helpwithXL Excel Programming 1 May 17th 05 04:57 PM


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"