Name limit range

[Hywel]

Morning All,
Is there a limit to the number of cells that can be defined in a name. I'm trying to select 30 rows from B through to G (B1:G1, B4:G4, B7:G7 etc) but having selected them all, and written in the name for the range the last, only 21 rows have been selected.
Is this the limit that excel has?
Thanks,
Hywel

[mangesh_yadav]

I could define the range for B1:G30.

Mangesh

[Carim]

Hi,

Yes there is a limit I forgot ...
but as usual there is a way around ...
the big Range... made of the Union all the small ranges ...

HTH
Carim