Selecting a variable print area in a macro

[Surrealest]

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]

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]

That worked wonders. Thank you very much

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