Activecell.activate dont work

[SECRET]

hi everyone!!
i need a urgent help on this one.
i recieve a excell sheet with macro that is running perfectly in
japan.
when i recieved it, it halt on the line with
activecell.activate
which is in the first line of the program.
the error says:
run-time error '-2147319784(80028018)':
Method 'Activate' of the 'Range' failed

does this error has to do with my operating system
which is win xp prof? or with my office 2000?

thank you very much!! and more power to you!!!

 

[BrianB]

ActiveCell.Activate is nonsense.
The Active Cell is active (and selected) by definition.
Try deleting this line of code.


Regards
BrianB
==============================================

 

[Bernie Deitrick]

Brian,

It's not nonsense.

It may not often be required, but it can be used when the selection
might be something other than a range - such as a drawing object. Then
the focus would move from the drawing object back to the activecell.

HTH,
Bernie

ActiveCell.Activate is nonsense.
The Active Cell is active (and selected) by definition.
Try deleting this line of code.


Regards
BrianB
==============================================



SECRET <[email protected]> wrote in message

http://www.ExcelForum.com/