Error: 1004: Application-defined or object-defined error

[Nlreid]

Hi,

This error pops up at the blue part I believe. Any idea why this is happening? Thanks!


Wend
Refresh_Click_Exit:
Exit Sub
Refresh_Click_Err:
MsgBox "Refresh_Click Error: " & Err.Number & ": " & Err.Description
Resume Refresh_Click_Exit

 

[Andrew Poulsom]

Hi,

This error pops up at the blue part I believe. Any idea why this is happening? Thanks!


Wend
Refresh_Click_Exit:
Exit Sub
Refresh_Click_Err:
MsgBox "Refresh_Click Error: " & Err.Number & ": " & Err.Description
Resume Refresh_Click_Exit

I doubt that. Can you post the rest of your code please?

 

[Ruddles]

Ten bob says there's a line somewhere near the top of the macro which reads: On Error GoTo Refresh_Click_Err.

Any takers?