Could it be that it is a chart sheet that is active, that is a sheet that
doesn't have a range.

--
HTH

Bob Phillips

"ch" wrote in message
...
My VBA sometimes works fine with
range("A1").select

Bt sometimes, it shows an error unless I include a "activesheet" in front
as
below :
activesheet.range("A1").select

Anyone please help me know why the additional "word" is needed ?