Preventing corruption of dynamic range names on cell deletion

C

Chrisso

Hi All

I have a simple dynamic range name with the formulae:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

When I delete cell A1 this range names becomes corrupt:

=OFFSET(Sheet1!#REF!,0,0,COUNTA(Sheet1!$A:$A),1)

This is very limiting and annoying! Is there anyway to get around this
problem?

Thanks in advance for any ideas,
Chrisso
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Multiple Dynamic Named Ranges across Columns 3
Dynamic Name Range using VBA 1
3d column chart dynamic range 0
Dynamic Range Name Anomalities 4
DYNAMIC RANGE FOR PIVOT TABLE 1
getting the absolute range address from a dynamic named range 2
Dynanic Print Range 2

Top