VBA reference a range of cells in WB array instead of manually typing names out

**Hoover5896** · 07-21-2017, 10:29 AM

Hello,

I am wondering how to reference a range of cells for the WbNames Array variable or if there is another way I have to do that? I have the work book names from below typed out in cells F2, F3, F4, etc, and rather have it reference that range instead of having to type the workbook names in VBA. That way I can change the WbNames in Excel.

Please Login or Register  to view this content.

**xladept** · 07-21-2017, 11:59 AM

Maybe:

Please Login or Register  to view this content.

**Hoover5896** · 07-21-2017, 02:52 PM

I am getting a subscript out of range for this part:

Please Login or Register  to view this content.

**xladept** · 07-21-2017, 03:00 PM

How many names do you have in column F?

**Hoover5896** · 07-21-2017, 08:17 PM

There are 8 workbook names

**xladept** · 07-21-2017, 08:26 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**xladept** · 07-25-2017, 04:24 PM

Hi Hoover,

Thanks for the rep!

Will you be uploading?

**Hoover5896** · 07-27-2017, 09:19 AM

Hi xladept,

Sorry I have been super busy. I actually figured it out. Thank you

**xladept** · 07-27-2017, 11:13 AM

Glad you got it!

VBA reference a range of cells in WB array instead of manually typing names out

LinkBack

Thread Tools

Rate This Thread

Display

VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Re: VBA reference a range of cells in WB array instead of manually typing names out

Thread Information

Users Browsing this Thread

Similar Threads

Vba to allow typing on on screen keyboard to populate range of cells

[SOLVED] Help with: Range Array SelectCase Loop delete: Array All Sheet.Names

[SOLVED] How to add a reference to an array or range of cells in an SQL query

Typing an array into a formula rather than referring to an array of cells

How to Create a Macro that automatically copies the cells in this range, when typing.

How do I get consecutive numbers without typing them in manually

[SOLVED] Are there any shortcuts to typing range names?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions