The code should be in a standard module not a sheet module.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"DKS"
wrote in message
Hi,
Stuck since a few hours now on a "Select Method of Range Class Failed"
error. The error is on a simple statement like

Range ("A1").Select

Just for info, I am scuttling back and forth (programatically) between two
opened workbooks using the instruction

Activewindow.Activatenext

I have no clue on why I am getting this error and what must I do to fix
this? I have used the range("A1").select so many times in the past without
problems that i am frustrated with this error that I am getting.
All help will be appreciated.