Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error handler | Excel Discussion (Misc queries) | |||
Error Handler Question | Excel Discussion (Misc queries) | |||
Error Handler | Excel Discussion (Misc queries) | |||
error handler | Excel Programming | |||
Error handler loop? | Excel Programming |