3 dynamic ranges in one column

[Littleme]

hello again!

Have a question about named (dynamic) ranges... Is it possible to have 3 named ranges spanning between empty rows?

Column will only contain text and first entry IS NOT a1.

Any takers?

 

[Smallman]

Hi

Happy to take up your problem provided you give a bit more clarity.

What do you mean by spanning between empty rows? Can you provide an example to show a bit more detail.

Take care

Smallman

 

[Littleme]

Hi!

Thank you for taking time to help.

Have uploaded a file. Need named range spanning between cells filled with yellow. Dont necessarily need to use blank cells as starting point of range (just an idea), could also use header right below (filled with green, and Named range itself).

Do you get where I'm going?

 

[Smallman]

Hi Littleme

I opened your file..... You have 37 named ranges.

So you need two named ranges between the cells in Yellow. Is that up to and meeting the cells in yellow?

It is probably possible but it is very difficult to make dynamic named ranges when you use the range below the range for some other purpose. All those filled cells from 23 down styme your capacity to generate a dynamic range in the cells from Row 4 to 11. Thoughts?

Take care

Smallman