Populate Cells with Named Range Values

[Macdave_19]

Hi All,

I want to run a macro when a cell is changed and populate Cell A12 With
the value in a named range.

The Name of that range is in cell A3

so i assumed i could do the following:

Please Login or Register  to view this content.

However its not working? any ideas people?

thanks for reading this thread all

[Macdave_19]

Hi All,

I want to run a macro when a cell is changed and populate Cell A12 With
the value in a named range. The list contains 4 items and needs to populate cells A12 to A15.

The Name of that range is in cell A3

so i assumed i could do the following:

Please Login or Register  to view this content.

However its not working? any ideas people?

thanks for reading this thread all

[royUK]

I'm not clear what you mean. Where does the named range come into this?

[royUK]

I can't understand what you are doing. Where's the named range?

[Macdave_19]

THere are 7 named ranges Called "GroupA" to "GroupH"

Theat are in a sheet called Lists GroupA is IN Cells A2:A5 Group B is in Cells B2:B5 and so on etc.

In My main sheet i have a Data Validation in cell C3 That has letters A>H in.

When i Change this the Macro runs. This cell also affect Cell A3 Which displays the required list name by doing the following:

Please Login or Register  to view this content.

I want this list to populate in cells A12:A15 (it has 4 team names in)

Hope thats a bit clearer

Alternatively i could use:

Please Login or Register  to view this content.

However i want to remove a team name from the list using VBA when another cell is change unless you can do something like:

Please Login or Register  to view this content.

[royUK]

Can you attach an example workbook?

[Macdave_19]

Here you go, i've added comments to help a bit

cheers for taking a look dude

[royUK]

I don't think your code is working because you are changing C3 with a control not a physical change. Try changing C3 manually or with Data Validation