Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
question
With Activesheet
.PageSetup.PrintArea = .Range(.Range("A1"), _ .Range("G200")).Address(External:=True) End With -- Regards, Tom Ogilvy "NascarIsKing" wrote in message .. . 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
question
Thank you very much Tom :)
NK "Tom Ogilvy" wrote in message ... With Activesheet .PageSetup.PrintArea = .Range(.Range("A1"), _ .Range("G200")).Address(External:=True) End With -- Regards, Tom Ogilvy "NascarIsKing" wrote in message .. . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
If question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |