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

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

I'm guessing that this code is behind a worksheet.

Unqualifed ranges in that kind of module refer to the sheet that owns the code.
And I'm guessing that "CT Summary" isn't the sheet that owns that code.

You could use:
Sheets("CT Summary").Select
Sheets("CT Summary").range("a1").select

or
application.goto Sheets("CT Summary").range("a1"),scroll:=true

But you don't usually have to select a range to work with it.

Sheets("CT Summary").range("a1").value = "hi there"

is one way to assign a value directly to that cell.

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

--

Dave Peterson

thank you dave. You're right (again). CT summary does not own that
code. I moved the code to a macro and called the macro and now it
works:)

thank you for the explanation though. I never knew that and it was
driving me insane that it wasnt working. but now i know why:)


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