Rohith1324
Board Regular
- Joined
- Feb 27, 2018
- Messages
- 114
Hi,
I have cell where there is simple formula as below :
And basis on the above cell I have VBA code where I am using the "If IsEmpty" -
but when I execute the code I think the code is not considering the cell as empty when
and its moving and executing the else part of it.
If IsEmpty(C.Offset(0, 75).Value) = True Then
Else
bot.FindElementByXPath("//*[@id='N317:QuantityShipped:" & (C.Offset(0, 75).Value) & "']").Clear
bot.FindElementByXPath("//*[@id='N317:QuantityShipped:" & (C.Offset(0, 75).Value) & "']").SendKeys C.Offset(0, 9).Value
End If
Could someone please assist on how to fix this.
Regards,
Rohith
I have cell where there is simple formula as below :
And basis on the above cell I have VBA code where I am using the "If IsEmpty" -
but when I execute the code I think the code is not considering the cell as empty when
If IsEmpty(C.Offset(0, 75).Value) = True Then
Else
bot.FindElementByXPath("//*[@id='N317:QuantityShipped:" & (C.Offset(0, 75).Value) & "']").Clear
bot.FindElementByXPath("//*[@id='N317:QuantityShipped:" & (C.Offset(0, 75).Value) & "']").SendKeys C.Offset(0, 9).Value
End If
Could someone please assist on how to fix this.
Regards,
Rohith