Value not appearing to VB

[pilot]

I'm using the code below to test for a non-blank entry in the cell named "Amount" but VB is allowing the test to pass with no entry in the field. This is working properly on other fields (except one) that are text. What have I forgotten?

If Len(Amount) = 0 Then
MsgBox "Amount must not be blank", vbExclamation
Cells.Range("Amount").Select
GoTo Lastline
End If

The other one that isn't working is a formula that currently resolves to False but it is passing the test also. Any help appreciated.

If LO = False Then
MsgBox "Problem with Loan Officer field", vbExclamation
Cells.Range("LO").Select
GoTo Lastline
End If

 

[Juan Pablo González]

LO is being assumed as a Variable. So, is it a variable ? try putting Option Explicit at the top of your module.

 

[pilot]

Did that and had to declare a couple other unrelated things. I'm using this code for LO.

Dim LO As String
LO = Workbooks("Sight Draft.xls").Sheets("SDA").Range("LO")

Wasn't sure if String or Boolean was proper so tried both, no difference, no improvement with Option Explicit.