Excel 2016 for Mac has forgotten who its parents are? Automation Error '-2147319767 (80028029)'

[nigelandrewfoster]

Hiya

This code works on Excel 2016 for Windows and Excel 2012 for Mac, but stops with the above error on Excel 2016 for Mac. Apparently it does not recognise the property 'Parent' anymore...?

Public Function Whole_Row(rngFirst As Range) As Range    Dim rngLast As Range
    
    Set rngFirst = rngFirst.Offset(, -rngFirst.Column + 1)
    Set rngLast = rngFirst.Offset(, 16383).End(xlToLeft)
    
[B]    If Not rngLast.Column = 1 Then Set Whole_Row = rngFirst.Parent.Range(rngFirst, rngLast)[/B]
    
End Function