Question Completion Status:

QUESTION $1$

On the following VBA code, what is the propose of the instruction $.$End$($XIToRight$)$

With wsData.Range$("$A$1")$

nColumns $=$ Range$(.$Offset $(0,0),.$End$($x$|$ToRight$)).$Columns.Count

End With

To determine automatic the numbers of unused columns in the worksheet

Method to determine the last used row

Method to determine the last used column.

Method to determine the last unused row