Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option of Print Preview or Save As
Hello,
I have the following code in my spreadsheet that does a "Find last row" and then gives me a print preview. The missing link is how can I get it to "Save as" after the preview? The preview is used to make sure the "Findlastrow" worked and for formatting. It can be either a choice to to to a message box that asks do you want to saveas or do you want to print preview? Obviously the selection would be operators choice..... Or can I put a save as dialog box into the print preview so that once it's reviewed I can save it? Sub findlastrow() Dim lastrow As Long Dim r As Range lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row Set r = ActiveSheet.Range("A1:P" & lastrow + 1) r.PrintPreview End Sub Thanks BOB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as PDF not same size as Print and Print Preview in Excel | Excel Discussion (Misc queries) | |||
Why is the "zoom" option grayed out in "print preview?" | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |