I searched around for the best way to this and am still a bit lost. I am trying to find the last non-empty cell in a column in Excel. In the past, there was a function _ExcelSheetUsedRangeGet($oExcel, $vSheet) in >this thread. However, much has changed since then and when I downloaded it I could not find that function to see how it worked.
Google found this site for me which offered a couple of promising looking approaches:
They are in VBA. I usually can convert VBA but I am not 100%