Creating named ranges is not a problem BUT (if I understand correctly) you
delete cells (not rows/columns) from range 1 (1-40) then data from range 2
will "move" up to replace the deleted cells. I can't see how you stop this.

You do seem to want to make life complicated!!

"driller" wrote:

Hello,

I have one workbook open, it has only one sheet in it....

Will it be possible to do this way...by code...or is there an existing one?

I want to divide the one-sheet into multiple groups of rows...

e.g. I place the criteria below <number of rows i need
<number of rows in grouped with distinct behaviour

A1 = 40
A2=1000
A3=2000
A4=25000
A5=(65536-A1-A2-A3-A4)

so if theres a macro,,,i run it and the result will re-arrange the behaviour
of this one sheet.
Meaning if i insert/delete cells or group of cells within the range A1:IV40,
the named_ranges from A41:IV65536 will not be changed dynamically.

Also the running state of the one sheet is that, it is logically behaving as
if they are divided into 5 separate sheets...where in fact they are just a
division of one 2003sheet such as these ranges...
A1:IV40
A41:IV1040
A1041:IV3040
A3041:IV28040
A28041:IV65536....
Regarding changes thru column *insert/delete* --Disabled
There must be no named_ranges that will over_lap with different group...

I can consider this to be the smartest macro i can find <to-date if there
is an existing one, for my end-goal for a stand-alone sheet <not Book...

thanks_and_regards,
driller

--
*****
birds of the same feather flock together..birdwise, it''s more worth
knowing the edges rather than focusing in one line! Know the limits and
remember the extents - dive with Jonathan Seagull