question

N

NascarIsKing

on the excel sheet that I have formatted, I forgot how to end it at a
certain point. In other words, lets say I want the page to end at line or
row 200 and Column G. How would I do that so when printing I dont have to
print selections. Thank you,
NK
 
T

Tom Ogilvy

With Activesheet
.PageSetup.PrintArea = .Range(.Range("A1"), _
.Range("G200")).Address(External:=True)
End With
 
N

NascarIsKing

Thank you very much Tom :)
NK


Tom Ogilvy said:
With Activesheet
.PageSetup.PrintArea = .Range(.Range("A1"), _
.Range("G200")).Address(External:=True)
End With
Click to expand...
 
Top