i am checking the legth of the cell has 5 do someting and greater than 5 it displays the message and stops the macro the macro shows here:
but it gives object error code
but i have in cell 4 e has 5 letter


if Len(aSheet.Cells(4,"e",5)) Then
MyScreen.Area(1,10,1,14).Value = aSheet.Cells(4, "e").Value
ElseIf Len(aSheet.Cells(4, "e").value) > 5 Then
MsgBox ("Corp should be 5 letters in Excel sheet ")