Selecting an unknown area of data

elgringo56 · Apr 28th, 2002, 03:57 PM

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 · Apr 28th, 2002, 04:07 PM

Try,

ActiveCell.CurrentRegion.Select

HTH,
Jay

elgringo56 · Apr 28th, 2002, 04:16 PM

That did it Jay, thanks heaps

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 28th, 2002, 03:57 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	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?

Apr 28th, 2002, 04:07 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Try, ActiveCell.CurrentRegion.Select HTH, Jay

Apr 28th, 2002, 04:16 PM	#3
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	That did it Jay, thanks heaps