Create dynamic name range

[merlino]

Hi Guys,

Is their a method in VBA or else where within excel to create a dynamic name range?

I have a range of C13 to IV5000, I would like to place BGColor front of each cell name, is this possible?

Any help would be much appreicated.

Thanks in advance.

[Bob Phillips]

It is not clear what you mean by ... place BGColor front of each cell name.

Do you want a separate name for each cell?

[merlino]

Yes, a sperate name for each cell.

eg: BGColourC13, BGColourC14......BGColourIV5000.

[royUK]

Why do you want that many Named ranges?

[merlino]

In a nut shell.

I have 2 work sheets with a pivot table on each, the pivote tables will grow and shink depending on data.

The first pivot table provides an int, This int is used in the conditional formatting of the second pivot table and because their on different work sheet I need to reference the range name of the cell to use the conditional formatting.

[Bob Phillips]

In a nut shell.

I have 2 work sheets with a pivot table on each, the pivote tables will grow and shink depending on data.

The first pivot table provides an int, This int is used in the conditional formatting of the second pivot table and because their on different work sheet I need to reference the range name of the cell to use the conditional formatting.

What's an int?

[merlino]

integer.....1,2,3,4 whole numbers.

[Bob Phillips]

Still missing why you need all those names. If PT1 returns a single number, wy can't the CF check against that?