Pulling Application.MoveAfterReturnDirection from value in cell?

[jmpatrick]

I'm trying to pull the Application.MoveAfterReturnDirection value from a cell on sheet. Unfortunately, the code below doesn't work. Is this possible?

Sub Load()

Range("Load!A1").Value = Application.Username
ActiveWorkbook.CustomViews(Range("Load!D1").Value).Show
Application.MoveAfterReturnDirection = Range("Load!C1").Value

End Sub

 

[jmpatrick]

OK. I tackled this another way:

Sub Load()

   Range("Load!A1").Value = Application.Username
   ActiveWorkbook.CustomViews(Range("Load!D1").Value).Show

    If Range("Load!C1").Value = "xlToRight" Then Application.MoveAfterReturnDirection = xlToRight
    If Range("Load!C1").Value = "xlDown" Then Application.MoveAfterReturnDirection = xlDown

End Sub