Selecting an unknown area of data

[elgringo56]

This has me stumped. I have an area 8 columns wide and 10000 rows deep. this area may contains a list of unknown size. it may be 1 row, 100 rows or any other number of rows deep. I want to select the area of true data. I tried using ActiveSheet.UsedRange.Select, but all the blank areas are selected also. Its as if Excel thinks these blank areas have something in them. Does anyone have any ideas?

 

[Jay Petrulis]

Try,

ActiveCell.CurrentRegion.Select

HTH,
Jay

 

[elgringo56]

That did it Jay, thanks heaps