try Range("BA1").activate


"biosci" wrote in
message ...

I have a change event procedure in Sheet1 that works very well with the
exception of probably the simplest component....selecting a cell. It
gives the following error message;

Runtime error '1004':

Select method of Range class failed

The line that it has the error on reads:

Range("BA1").select

I have writen page after page of macros and this usually works (as it
should). It should be quite a simple procedure. I have ensured that
the sheet is visible and unlocked etc, so that shouldn't be a problem.
The cell is on a different sheet to the sheet the procedure is iniated
from, but i wouldn't have thought that would cause an error. I am sure
the fault is simple, but can't for the life of me find the solution.

What am I doing worng and why won't this simplest of codes work for me?


--
biosci
------------------------------------------------------------------------
biosci's Profile:
http://www.excelforum.com/member.php...o&userid=32827
View this thread: http://www.excelforum.com/showthread...hreadid=530296