Naming an undefined range

[jomili]

I need to give a name to a range of data I'm pulling from another spreadsheet, as a precursor to doing a VLookup. I looked online and found what I thought would do the naming for me, but it's only naming the range A1. Can anyone point out what I'm doing wrong?

I've copied the last few routines of my code so you can see what's happening. The steps are these: Filter data on the Sheet1 (in another workbook, the APRWkb workbook), copy that data to the APRdata worksheet in my active workbook, rearrange the columns, insert a formula after the pasted data, create two new row headings, format everything nice and neat, and finally try to name my range. As I've said, it appears to only be naming A1 instead of the entire selection. Can I get some help on this one?

Thanks.

Please Login or Register  to view this content.

[Richard Schollar]

Instead of this:

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

Richard

[6StringJazzer]

You've described everything except what range you want to name.

Here's what your code does:

Locate cell A1. Find the cell at the top of the range containing A1. This will always give you A1. Then take the offset. An offset with 0,0 has no effect, not sure what the intent is.

If you want to name the range you just selected you can do this:

Please Login or Register  to view this content.

This invites the question as to why you want to select that range in the first place, unless for some reason you want it set up that way for your user. If selection is not really needed then

Please Login or Register  to view this content.

[Leith Ross]

Hello jomili,

You can set the named range to column "A" using this method:

Please Login or Register  to view this content.

[jomili]

Wow! Three alternative (and apparently all correct) answers within an hour. I like that response!

Thanks for all of your help, encouragement, and support!