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

 

[BrianB]

You have left off the quotes in Range("N4")

 

[loopoo]

That was the problem

Thanks for your help,
Chris