This refers to copying a cell from one sheet to the other, where EACH sheet has LOCAL ranges Foo1, Foo2, Foo3, Foo4, and every time I copy the cell I get 4 nags. Excel 2003.

I understand why the message occurs. No need to explain that. I just want to know if there is a trick (e.g. system variable) to getting rid of the nag - other than paste special, or using VBA to do the copy. I go Ctrl-C/switch sheet/Ctrl-V a LOT and the 4 nags that I get on every copy is draining my strength.

If you answer "here's how to do the copy in VBA avoiding the nag" or "here's how to use paste special avoiding the nag" check your jockstrap cup first. This is a nontraditional question seeking (if it exists) a [documented?] feature. Thanks!

(Bonus "polling" question if you're motivated: of curiosity, has anyone ever not clicked Yes (or hit Enter) on the nag? I expect to hit Yes every time in my entire life, for my usage pattern and everyone's I've ever spoken to.)