Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What I would like to do:
If Not IsError(ChDir [B5]) Then ChDir [B5] more code End If But of course IsError isn't for this kind of error. How should I do it? Thanks, Tim C |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Error Resume Next
ChDir [B5] If Err.Number = 0 Then 'more code Debug.Print "ok" Else 'deal w/error Debug.Print Err.Number End If -- Bob Kilmer "Tim C" wrote in message ... What I would like to do: If Not IsError(ChDir [B5]) Then ChDir [B5] more code End If But of course IsError isn't for this kind of error. How should I do it? Thanks, Tim C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling | Excel Discussion (Misc queries) | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Error handling | Excel Programming | |||
Error Handling | Excel Programming | |||
Error Handling | Excel Programming |