RWayneH
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER