HELP PLEASE- SELECTING A RANGE

Posted by Jiminey Dehey on February 10, 2002 11:23 AM

I have data in a range lets say A1 to E50. I want to select the range only down to the last entry in the "A" column, for example, if I only have data from A1 to A20, then I would want A1 through E20 selected. Please help. thanks

Posted by Zzyzzyth on February 10, 2002 12:12 PM

Provided you have column headings from A1 to E1, you could use Edit>Go To>Special>Current Region

Posted by Polonius on February 10, 2002 2:58 PM

Range([A1],[A65536].End(xlup)).Resize(,5).Select