Syntax error

[loopoo]

Hi!

I'm trying to select a cell when an event comes (worksheet activation)

Application.Goto ThisWorkbook.Worksheets("INDICATORS List").Range(N4)

is the line and the error message I get is: "Application-defined or object-defined error"

Can anyone help me in selecting the "N4" cell from "INDICATORS Lists" when activating another worksheet ?

Thanks in advance,
Chris

[Norman Jones]

Hi Chris,

Your syntax works for me, providing the cell reference is enclosed in
quotes:

Application.Goto ThisWorkbook. _
Worksheets("INDICATORS List").Range("N4")


---
Regards,
Norman



"loopoo" <[email protected]> wrote in
message news:[email protected]...
>
> Hi!
>
> I'm trying to select a cell when an event comes (worksheet activation)
>
> Application.Goto ThisWorkbook.Worksheets("INDICATORS List").Range(N4)
>
> is the line and the error message I get is: "Application-defined or
> object-defined error"
>
> Can anyone help me in selecting the "N4" cell from "INDICATORS Lists"
> when activating another worksheet ?
>
> Thanks in advance,
> Chris
>
>
> --
> loopoo
> ------------------------------------------------------------------------
> loopoo's Profile:
> http://www.excelforum.com/member.php...o&userid=28792
> View this thread: http://www.excelforum.com/showthread...hreadid=487163
>

[Charlie]

I don't know about the rest of the line, but you need quotes around N4 in the
range:

Range("N4")

"loopoo" wrote:

>
> Hi!
>
> I'm trying to select a cell when an event comes (worksheet activation)
>
> Application.Goto ThisWorkbook.Worksheets("INDICATORS List").Range(N4)
>
> is the line and the error message I get is: "Application-defined or
> object-defined error"
>
> Can anyone help me in selecting the "N4" cell from "INDICATORS Lists"
> when activating another worksheet ?
>
> Thanks in advance,
> Chris
>
>
> --
> loopoo
> ------------------------------------------------------------------------
> loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
> View this thread: http://www.excelforum.com/showthread...hreadid=487163
>
>

[loopoo]

Thank you both for your replies.

It's working now.

Chris