Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the following code the IsError function is returning False when the
cell contains #N/A. Any idea on what I'm doing wrong? Do Until IsEmpty(ActiveCell.Offset(0, 5).Value) If IsEmpty(ActiveCell.Value) And Not IsEmpty(ActiveCell.Offset(0, 13).Value) Then 'if price is empty, and Bloomberg price is not If Not IsError(ActiveCell.Offset(0, 13).Value) Then 'fill column V only if V is empty If IsEmpty(ActiveCell.Value) Then ActiveCell.Value = ActiveCell.Offset(0, 13).Value End If End If End If Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF, OR, ISERROR? | Excel Worksheet Functions | |||
Iserror not working as expected | Excel Worksheet Functions | |||
ISERROR | Excel Worksheet Functions | |||
Iserror | Excel Discussion (Misc queries) | |||
ISERROR formula in VBA not working for me | Excel Programming |