That sounds like an excellent Bug to report to the Office 2007 development
group. Save that file so you can reproduce it and perhaps even provide it to
them.

In the case of such an error, Excel should toss up the [End] [Debug] option
dialog rather than failing completely.

"tires85" wrote:

I am using the Beta Office 2007 and when I'm working on my spreadsheet to
enter data which has macros, it will work fine for a few minutes, then I get
an error which says Method 'Activate' of object 'Range' failed. Then I have
to shut completely down and open Excel again. Can anyone help me on this?
Thanks.