Problem with script error in chart

[Meenie]

I have excel 2003.
I have a BIG spreadsheet with a worksheet for each month. Each worksheet has a lot of formulas.
I have a little macro that makes the sheet open to a specified line because it's so big it always opened to a weird line and you had to remember to scroll to the right line before entering info.
The problem I'm encountering I "think" is related to the macro. When I create a chart and put it in it's own sheet instead of on the sheet where it was created, I get an error message that says:
"runtime error '1004': Method 'range' of object '_Global' failed.
then I have a choice of "end" or "debug"
I can click "end" and the error message goes away, but I'd rather not have that popping up. But I have no idea how to debug it. If I click debug it takes me into vb with all kinds of stuff in there and I have no idea what to do.

 

[pbornemeier]

Someone wrote the VB code that is not executing correctly -- talking to that person would be the best way to find out what is happening. If that can't be done, then paste a dozen lines above and below the line that is highlighted. (Be sure to indicate which line is causing the error.) And we can give it a shot.

It sounds as if there is a problem in the NewSheet workbook event - probably the code there was written assuming that the new sheet would be a worksheet and not a chart.

 

[Meenie]

Here's what I see when I hit "debug"
<code>Private Sub Workbook_Open()
Application.Goto Sheets("Jan").Range("C4"), True
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.Goto Range("C4"), False
End Sub</code>

If I go into VB here's what I see:
<code>Private Sub Workbook_Open()
Application.Goto Sheets("Jan").Range("C4"), True
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.Goto Range("C4"), False
End Sub</code>

does that help?

 

[Meenie]

Nevermind I fixed it.
first I tried to change the "true" to "False" and that didn't work.
so then I tried just deleting that line, and it worked.
I just didn't know what to do with that debugger.
No matter what I did, when I'd click it off it would say something like This Action will cause the debugger to stop, is this ok?
LOL

 

[Weaver]

I think the problem is that the code can't differentiate between worksheets and a dedicated chart sheet and since charts don't have cells, it can't very well go to cell C4.

The true/false bit just decides whether to scroll or not, again not possible on a chart sheet.

try

if sh.type <> 2 then Application.Goto Range("C4"), False

since if the sheet's type is 2 it will be a chart.

 

[Meenie]

Thanks!

thank you both for your help!
Weaver - I'll try that :D