Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know why this will not go to No_Profit...1st error check works
fine but second gives me an error Thanks Range(Cells(x - 1, 1), Cells(Last_Entity, 1)).Select On Error GoTo No_Rev Selection.Find(What:="REVENUE").Activate Rev_Top = ActiveCell.Row + 1 Selection.Find(What:="TOTAL REVENUE").Activate Rev_Bottom = ActiveCell.Row - 1 No_Rev: On Error GoTo No_Profit Selection.Find(What:="DEPT PROFIT").Activate Profit_Top = ActiveCell.Row + 1 Selection.Find(What:="TOTAL DEPT PROFIT").Activate Profit_Bottom = ActiveCell.Row - 1 No_Profit: -- Helping Is always a good thing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question on "On Error GoTo skip" | Excel Discussion (Misc queries) | |||
On error GoTo Question | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming |