Put bottom border on last used cell

Hi guys, i need to be able to put a bottom border on the alst used cell on a worksheet, using find special cells > last used cell doesnt work it returns an incorrect cell (because i am importing 300 rows from an external sheet it see's all 300 as used cells regardless if they're blank or not)

I was thinking a way i could achieve this would be to look in column I for an xlLeft border, and continue down each cell until that cell does not have a border. Then for that row between columns A-H put an xlTOP border on

Thanks heaps