Are named ranges not automatically visible to VBA?

**Sidewinder72** · 09-21-2018, 06:00 AM

My sheet has a range named "Morris" (B10 through C14) which I want to become a rowsource at some point for ListBox1. (I defined this range outside of VBA, just by selecting the range and right clicking on Define Name.)

Please Login or Register  to view this content.

gives a runtime error 13; type mismatch.

Do I need to write a line of code that defines the range "Morris"? I was sort of counting on VBA being able to find it, the same way it knows how to find Range"A1" etc.

**Norie** · 09-21-2018, 06:16 AM

If you want to use the named range for the RowSource all you need is the name.

Please Login or Register  to view this content.

**Sidewinder72** · 09-21-2018, 06:19 AM

I'm used to VBA benig far more byzantine than that!!!!!

Thank you Norie.

**WideBoyDixon** · 09-21-2018, 06:20 AM

What about:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

?

WBD

Are named ranges not automatically visible to VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Are named ranges not automatically visible to VBA?

Re: Are named ranges not automatically visible to VBA?

Re: Are named ranges not automatically visible to VBA?

Re: Are named ranges not automatically visible to VBA?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Named Ranges, automatically say yes to overwritting them.

[SOLVED] Named Ranges in Excel that Automatically Expand

[SOLVED] VBA creates named ranges, but named ranges disappear

[SOLVED] Trying to use multiple named ranges in the body of an automatically sent email from Excel

[SOLVED] Multiple drop down list that automatically update using offset and named ranges

Automatically combine data in two named ranges

[SOLVED] Automatically increase Named Ranges

Bookmarks

Bookmarks

Posting Permissions