PC Review


Reply
Thread Tools Rate Thread

Dealing with Named Ranges when Importing Worksheet from Another File

 
 
excel wonk
Guest
Posts: n/a
 
      19th May 2007
When you are using range and name functions a lot, what's the best way
of importing a worksheet from another file? It goes through a whole
loop where asking whether to use the name defined in the destination
sheet. I just press the enter down until but there must be a better
way.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing named ranges from excel amk Microsoft Access External Data 1 30th May 2008 11:06 PM
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... christian_spaceman Microsoft Excel Programming 3 24th Dec 2007 01:15 PM
Importing named ranges DZ Microsoft Access External Data 1 10th Dec 2007 11:32 AM
"No named ranges" error importing from xls file... Alphonse Microsoft Outlook Contacts 10 17th Aug 2007 06:34 PM
Importing Named Ranges in MS Query =?Utf-8?B?S0hhbm5h?= Microsoft Excel Discussion 0 21st Jul 2006 09:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:35 PM.