Select Code to Download

sub Get_Last_Row
{
...
                                            SearchDirection=>xlPreviou
+s,
                                            SearchOrder=>xlByColumns})
+->{Column}
}

#my $LastRange = $LastCol.$LastRow;
$LastRange = 'IV'.$LastRow;
$ArrayData = $DataSheet-> Range("A1:$LastRange")->{Value};