VBA MoveAfterReturnDirection state

[craigexcel]

I have searched this forum for "MoveAfterReturnDirection", but didn't see any posts about the current state of the move direction.
The workbook has a number of macros that will run based on entries in specific Columns. As a result, when anyone uses the workbook, I want the 'direction' setting to be 'turned off', via VBA, so the current Row can be captured acurately and saved in a variable. While I can do that easily enough, I want to be able to restore the user's previous setting to what it was before they opened the workbook, in case the user has a specific direction already set that is used as their default.

So, my question is, how do you capture the current state of MoveAfterReturnDirection?

I did try, via some ad hoc VBA code, setting the direction to each of the 4 different ways, and then had the 'result'(?) display via MsgBox. Each direction returned -4161.

I'm using Office 365 (@ work).

 

[NoSparks]

Interesting. With my Excel 2010 using

? application.MoveAfterReturnDirection

in the immediate window gives these
-4159 for left
-4162 for up
-4161 for right
-4121 for down

 

[MARK858]

With my 365 I get

? application.MoveAfterReturnDirection
-4121
? application.MoveAfterReturnDirection
-4159
? application.MoveAfterReturnDirection
-4162
? application.MoveAfterReturnDirection
-4161

 

[craigexcel]

Thanks for both replies. There must have been something in the test code I was using that was slightly off. I appreciate your feedback.