Subor sa mi neda nahrat tak prikladam len makro. Z tvojho makra vymaz kod a vloz tento:
Sub POSLEDNY_RIADOK()
Dim lRow As Long
Dim lCol As Long
'Find the last non-blank cell in column A(1)
lRow = Cells(Rows.Count, 1).End(xlUp).Row
'Find the last non-blank cell in row 1
lCol = Cells(1, Columns.Count).End(xlToLeft).Column
MsgBox "Posledny riadok: " & lRow & vbNewLine & _
"Posledny stlpec: " & lCol
Range(Cells(1, 1), Cells(lRow, lCol)).Select
Worksheets(1).Range(Cells(1, 1), Cells(lRow, lCol)).Borders(xlEdgeTop).Color = RGB(255, 0, 0)
Worksheets(1).Range(Cells(1, 1), Cells(lRow, lCol)).Borders(xlEdgeBottom).Color = RGB(255, 0, 0)
Worksheets(1).Range(Cells(1, 1), Cells(lRow, lCol)).Borders(xlEdgeLeft).Color = RGB(255, 0, 0)
Worksheets(1).Range(Cells(1, 1), Cells(lRow, lCol)).Borders(xlEdgeRight).Color = RGB(255, 0, 0)
End Sub