Thread: Error Handler
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dht[_2_] dht[_2_] is offline
external usenet poster
 
Posts: 13
Default Error Handler

I have tried this and it doesn't appear to work I'm using Excel 2000 if this
helps.

Dave

"Auric__" wrote in message
...
On Wed, 18 Aug 2004 13:59:30 +0100, dht wrote:

I'm trying to use an error handler that uses the Goto label command.

Sub Section_1()

On error goto handler

' my code
Exit Sub

Handler:

Cells.Select
With Selection.Interior
.ColorIndex = 2
.Pattern = xlSolid
End With
Range("G6").Select
ActiveSheet.Pictures.Insert( _
"\\\files etc pics \logo.jpg" _
).Select
Selection.ShapeRange.IncrementLeft 14.25
Selection.ShapeRange.IncrementTop -58.5

End Sub

I can't get the code after the handler error to run what am I missing /
doing wrong.


Try making this change:

Handler:
Err.Clear
' the rest of your code here

--
auric underscore underscore at hotmail dot com
*****
Excuse me, but your ass is on your chin.