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
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