Identifier under cursor is not recognised - why?

[01jenbad]

Hi

I have applied the following in order to filter across multiple sheets. I added the Errorcatch in after a 400 error appeared. The error is now appearing as Compile error: Label not defined. Then if I click 'ok,' the top line is highlighted yellow, with an arrow pointing to it from the left. If I right click on the arrow, and click 'Definition,' there is the error 'Identifier under cursor is not recognised'

This is the code I have entered. Can you please help with my error?

Sub apply_autofilter_across_worksheets()
On Error GoTo Errorcatch
Dim p As Integer, q As Integer
p = Worksheets.Count
For q = 1 To p
With Worksheets(q)
.Range("J22").AutoFilter field:=1, Criteria1:=">0.001"
End With
Next q
Exit Sub
End Sub

Much appreciated

Jenny

[Norie]

The error is because you don't have a label in the code named ErrorCatch.

Using right click>Definition is used to find variables, subs, objects etc.

It won't find labels or other parts of the code, try using it on With or For.

PS Can you add code tags when posting code?

[01jenbad]

I have never used code before yesterday and am just trying to teach myself in order to come up with a solution to a problem in work. So, unfortunately, I don't know what you mean! How would you retype the code?

The original code without errorcatch was:

Please Login or Register  to view this content.

[Norie]

What error are you trying to deal with?

[01jenbad]

Without the Errorcatch bit in, there is just an Error 400 that appears. I saw online somewhere that adding in the errorcatch bit might show what was wrong. So it is the case that I need to add the errorcatch bit in correctly (if so - how) or can you see an error in the above bit of coding without the errorcatch.

Sorry if this is confusing - I'm not entirely sure what it should look like, so finding it difficult to know what's wrong!

Thanks for your help

[Norie]

Adding On Error is more likely to hide the error.

Is there no message when you get the error? Do you know if it happens on a particular sheet?

If you really want to use On Error you could do it like this, assuming the error is on the Autofilter line.

Please Login or Register  to view this content.