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.