I am not sure that I fully understand what you are trying to achieve. Can you
answer the following questions so that I can get a firm understanding of what
you are trying to explain:-

1. What is the initial range of WorkArea prior to inserting columns?
2. How many columns you insert? (Make up a number if it varies)
3. What is the range of WorkArea after you insert the columns?
4. What range would you like WorkArea to be after inserting the columns?

Regards,

OssieMac





" wrote:

On Sep 5, 1:21 pm, wrote:

Mr. OssieMac

Thank you for responding to the query.

My concern is that named ranges (created in Define Name space) should
reflect the prevalent states of the worksheet when the corresponding
columns or rows are inserted or deleted thereof.

In this case, the interaction linkage between worksheet and Define
Name space is akin to Swiss Cheese ; there are holes in the whole
thingy and hence weakening the interaction process.

Would like to add that,

TitleCount = SUM(IF(MID(
OFFSET('Sheet1'!WorkArea,0,4,ROWS('Sheet1'!E$2:E6) ,1),1,100)=
MID('Sheet1'!E6,1,100),1,0))

Since the given ranges of the above formula do not reflect the
prevalent states of the worksheet when the corresponding columns (such
as would be taking place within the Range of E$2:E6) are inserted or
deleted thereof,

Consequently, TitleCount would not compute correctly.

Is there any alternative means to work around this difficulty ?

Please share your experience.

Regards.