Link to home
Start Free TrialLog in
Avatar of RWayneH
RWayneHFlag for United States of America

asked on

Help with an If statement.

Why is Ln4 failing?  E39 is blank and it is skipping to the Else?

       If Not ActiveCell = "" Then ' Cell is NOT blank, continue
        Range("A1").Select
        ActiveCell.Offset(37, 4).Range("A1:C1").Select
        If ("E39") = "" Then   'check the cell under A1, which is actually E38
            Selection.Copy
        Else
            Range(Selection, Selection.End(xlDown)).Select
            Selection.Copy
        End If

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RWayneH

ASKER

Thanks for the help.