Dim myColumns As Range
Dim myRange As Range
Set myColumns = Columns("N")
With myColumns
Set myRange = .Find(What:="*", After:=.Cells(1), _
LookIn:=xlValues, Searchorder:=xlByRows, _
SearchDirection:=xlPrevious)
End With
With ActiveSheet.PageSetup
.PrintArea = "A14:N" & myRange.Row
End With
Set myColumns = Nothing
Set myRange = Nothing