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.

« Save All | automate dates »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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