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
