Activecell.activate dont work

  • Thread starter Thread starter SECRET
  • Start date Start date
S

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!!!
 
ActiveCell.Activate is nonsense.
The Active Cell is active (and selected) by definition.
Try deleting this line of code.


Regards
BrianB
==============================================
 
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


BrianB said:
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
Click to expand...
http://www.ExcelForum.com/
 
Back
Top