hello,

In one sheet, i need to make a named range,
starting on A1
Ending on cell #?

if the last non-empty cell is in row 6000
and
if the last non-empty cell is in column IR
then place a value on cell IR6000="A1:IR6000" *as embedded range address"
and
the last non-empty cell criteria shall only include Columns "A:IS" and Row
"1:65535"

the embedded range address shall be used in the defined name, indirectly.

thanks for your advice..

regards
--
*****
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