close
How do you use Excel's quot;iserrorquot; in VBA? I have a macro that uses a search
result and I want the macro to skip to the end if the search returns quot;#N/Aquot;
Dim V As Variant
' code that sets V to something
If IsError(V) = True Then
' do something
Else
' do something else
End If--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Ken G.quot; gt; wrote in message
...
gt; How do you use Excel's quot;iserrorquot; in VBA? I have a macro that
gt; uses a search
gt; result and I want the macro to skip to the end if the search
gt; returns quot;#N/Aquot;
全站熱搜
留言列表
