| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting a variable print area in a macro
That worked wonders. Thank you very much
"Dave Peterson" wrote: Dim myRng as range set myRng = nothing on error resume next set myrng = application.inputbox(Prompt:="Select a range", type:=8) on error goto 0 if myrng is nothing then msgbox "Try again later" 'user hit cancel else myrng.printout end if Surrealest wrote: I need to be able to select a variable print area in a macro. every time I use the macro I need to be able to highlight a different range for printing. When recording the macro I entered in a range ("B5:G23") but now I need that to be a selectable variable before I print. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable print area via a macro | Excel Discussion (Misc queries) | |||
| Using named range to extend print area for variable number of columns | Excel Worksheet Functions | |||
| Selecting Print area in protected worksheet | Excel Discussion (Misc queries) | |||
| Method of selecting an area with a macro | Excel Worksheet Functions | |||
| Variable print area | Excel Discussion (Misc queries) | |||
Threaded Mode
