Oh, ok, I'm following you now. If all I was looking at was to make
sure that the same row or column was inserted in both sheets, then I
think you are right that this would work. However, I need to ensure
that EVERYTHING (formatting AND data entry) that is done on the data
entry sheet is done on the final product sheet. So I'm looking for it
to automatically select the sheets. I do greatly appreciate the
suggestion and your time.

Frank

On Sat, 16 Apr 2011 13:36:39 -0400, GS wrote:

Phrank expressed precisely :
For Garry, the reason I want it in an event is because I and others
periodically forget to select both tabs, which leads to extra work.
I'm just as likely to forget to right click and run this from a menu
item as I am to actually select both tabs. ...unless you were
thinking of something else. The automation of the procedure is what
I'm after, and Jim's fixing of my code seems to do the trick.

Thanks!

Frank

I'm glad Jim was able to help you. My thinking was that SINCE YOU MUST
USE A MENU FROM SOMEWHERE (menubar or cell popup) to insert rows/cols
then why not 'train' yourself and your users to use your own custom
menus for automated tasks.

Using event code constantly adds to performance overhead; using a
menuitem only adds when needed!