import values from named range in another workbook

**batchjb69** · 03-31-2016, 05:09 PM

Hi

I want to import values in a named range from another workbook into my main workbook without using copy and paste. I'm using the below but it only imports the first value of the named range. Any ideas how to resolve this.

Please Login or Register  to view this content.

**graym463** · 03-31-2016, 05:29 PM

You need to identify how many cells are in the 'named range', and then set your values accordingly. You currently have set only Cell "A1" to pull in data from book1.

Please Login or Register  to view this content.

**LeoTaxi** · 03-31-2016, 05:48 PM

Something like this

Please Login or Register  to view this content.

Kind regards
Leo

import values from named range in another workbook

LinkBack

Thread Tools

Rate This Thread

Display

import values from named range in another workbook

Re: import values from named range in another workbook

Re: import values from named range in another workbook

Thread Information

Users Browsing this Thread

Similar Threads

How to move a named range reference to an identicle range when copying to another workbook

[SOLVED] VLookup on data from one workbook from a named range on a different workbook

[SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.

Import Named Range from multiple Excel Workbooks

VBA - Copy values from each named range in a workbook

Macro to copy named range "box" values to named range "box2". Both are size of 5x26

[SOLVED] Outlook wants an Excel named range to import contact data why?

Bookmarks

Bookmarks

Posting Permissions