| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Script to Print Range of Cells
Hi all -
I have the default print area already set for a certain space. I need to write a script for a 2nd print area. Here is what I have so far...but am at a loss as to have it show up correctly in print preview. Any Help is Greatly Appreciated! Private Sub Application.ScreenUpdating = False ActiveSheet.Range("GG2500:GM2745").AutoFilter Field:=1, Criterial:="<" Range("GG2500:GM2745").Select Application.PrintPreview End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get in a vbs script the sum of values of a Excel cells in a certain range? | Excel Discussion (Misc queries) | |||
| Print Named Cells highlights web link to Excel range | Excel Discussion (Misc queries) | |||
| Dynamic Print Range with cells containing formulas ! | Excel Discussion (Misc queries) | |||
| NOT Printing certain cells within the print range | Excel Discussion (Misc queries) | |||
| Macro script for setting Print Area | Excel Discussion (Misc queries) | |||
Threaded Mode
