| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax error
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 o object-defined error" Can anyone help me in selecting the "N4" cell from "INDICATORS Lists when activating another worksheet ? Thanks in advance, Chri -- loopo ----------------------------------------------------------------------- loopoo's Profile: http://www.excelforum.com/member.php...fo&userid=2879 View this thread: http://www.excelforum.com/showthread.php?threadid=48716 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
Thank you both for your replies. It's working now. Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=487163 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| syntax error | Excel Programming | |||
| variable not declared error & syntax error | Excel Programming | |||
| Syntax error Q | Excel Programming | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
| Where is my syntax error? | Excel Programming | |||
![loopoo[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
