Try this:

Sheets("CT Summary").Activate
Activesheet.Range("A1").Select

Randall Arnold

"tkaplan" wrote:


I have a line in my code:

Sheets("CT Summary").Select
Range("A1").Select

when i run my code, the debugger stops at the range.select line. the
cell is not hidden, the sheets are not protected.
the error i get is:
runtime error 1004: select method of Range class failed.

i cant figure out what is wrong with this. any suggestions?


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=479822