thanks JE McGimpsey...

Suppose I have Sheet1, Sheet2 and Sheet3 on Workbook "tst.xls".

If i typed a formula in Sheet1 with function like offset(..) and other
non-dynamic cell referencing function...I like a friendly macro to restrict
or stop me from inserting cells or rows or columns in Sheet1 only.....

I am used on office WYSIWYG concept under a single yet large spreadsheet,
and at the same time, I am old and often forget the restrictions (i.e. dont
insert cell on a referred array) of such function's functionality in a daily
dynamic spreadsheet...

I am old to build a Macro like others suggest.

I hope we will not argue about the difference of being old and being
careless <sorry a wrong word that I had described previously

Pls. dont hang up..thanks

"JE McGimpsey" wrote:

If you're spreadsheet design is so careless (your words) that you can't
keep track of what ranges you're using, then I'd expect that it's very
unlikely that adding VBA to the mix will help.

That said, I also clearly don't understand what you're looking for.



In article ,
driller wrote:

I like to use the worksheet functions like "offset"....yet i am so careless
in inserting columns and rows and cells on the spreadsheet. I am always
forgetting the importance of an established range that is referred by offset
formula and other referencing function..hence
I request for a VBE medication that will always freeze the insertion or
deletion of cell, row or column -in a spreadsheet - which contain any of this
referencing formula like offset...I cannot always remember the
precaution...please help...this is the 2nd post since yesterday.