[vba]Range(Application.InputBox("Get Range ", "Title", , , , , , 2)).Select[/vba]will work also, but I'm guessing grohm's trying to figure out why his original code doesn't work