| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Print Area
Hello guys!
Can I have your help; I have an range with data A1:T20. Can you define it as print area if it contains any letters or numbers in cell G10? Thanks! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Print Area
Hi Nick,
Am Tue, 22 Jul 2014 19:25:00 +0100 schrieb Nick31: Can I have your help; I have an range with data A1:T20. Can you define it as print area if it contains any letters or numbers in cell G10? in the code window of your sheet: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(0, 0) < "G10" Then Exit Sub PageSetup.PrintArea = IIf(Len(Target) 0, "$A$1:$T$20", "") End Sub Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| Macro - Set Print Area for Changing Data Area | Excel Programming | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Linear Mode
