ListObject.DisplayRightToLeft (Excel)

True if the specified ListObject is displayed from right to left instead of from left to right. False if the object is displayed from left to right.

Dim booDisplayRightToLeft As Boolean
booDisplayRightToLeft = ActiveCell.ListObject.DisplayRightToLeft