|What version of Excel are you running?|
With Excel 2010 running under Win 7, I can select a range, choose File...Print and go to screen with a number of drop downs under Settings. The first drop down defaults to Print Active Sheets, but the drop down allows me to choose Print Selection.
Another option is to select your range and use the Page Layout ribbon where you can Set/Clear the Print Area.
I hope that helps!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.