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

Hi,

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.

Thanks
Dave